Advanced Drag Drop Operations Link to a Specific Excel Cell or Range
Advanced Drag Drop Operations Link to a Specific Excel Cell or Range Have you ever tried linking an AutoCAD object to a specific cell or row? For example, you might want to link a door block with a specific row inside the door schedule. Follow the easy steps to accomplish the task. Keep the Excel file and the drawing open. Select the required cell by clicking on it. Move the cursor towards the side of the cell until you see the move symbol (Similar to what you see inside the lens in zoom extents button icon). Now right click and drag the cell to the AutoCAD window. On releasing the right mouse button, you will be provided with a menu containing a menu item Create hyperlink here as shown below. Select the AutoCAD entity to be linked when prompted for object selection. Close the excel file and click on the AutoCAD entity holding down the Ctrl key to check the link. You can modify the above link to select a range of cells instead of a single cell.Press Ctrl+K and select the previous AutoC...