neuri 10 Posted January 11 Hello, I need some help linking to specific cells in an excel spreadsheet. I have a large list of mechanical services that I need to plot in to a table for each equipment, I want to make a generic table and link each cell to a specific cell in my excel file. For example: I drew this table in excel, the Cell A1, G1, A24 and F24 refer to the cells in my excel spreadsheet. ________________________ |_Cell A1___|_Cell G1___| |_Cell A24__|__Cell F24_| So when I update the spreadsheet, the table also updates automatically. Right now i can use Data Link, but it links the entire excel sheet, blank MEP tables etc., I just want specific cells. Is this possible? I googled and saw something similar in the LISP forum but i don't even know how to begin to read LISP code. Quote Share this post Link to post Share on other sites
BIGAL 496 Posted January 11 Your profile says you have LT correct ? That may be a problem. Quote Share this post Link to post Share on other sites
neuri 10 Posted January 11 3 minutes ago, BIGAL said: Your profile says you have LT correct ? That may be a problem. Oh, didn't see my profile. My office just upgraded us to ACAD 2021 with new laptops. But even in 2014 LT, i was able to link excel sheets. Now, I just want to link to specific cells. Quote Share this post Link to post Share on other sites
BIGAL 496 Posted January 12 Found a possible answer after googling. Copy a cell in excel Paste special in Autocad, choose link. Quote Share this post Link to post Share on other sites
SLW210 117 Posted Tuesday at 02:16 PM Copy the cell(s) in Excel>Paste Special in AutoCAD>Paste Link>AutoCAD Entities>OK then place where desired. Quote Share this post Link to post Share on other sites
BIGAL 496 Posted Wednesday at 05:34 AM (edited) SLW210 your explanation was the same as mine but better described. Why not click cell excel then Ctrl+C Go to Autocad Alt+Ctrl+V hope I have enough fingers. Edited Wednesday at 06:08 AM by BIGAL Quote Share this post Link to post Share on other sites
neuri 10 Posted Wednesday at 01:54 PM Oh.. there's multiple entries, steam/hot water/cold water/chilled water/gas/electricity/vacuum/air pressure etc. and there's roughly 60+ equipment. I was hoping there's an easy way but copy pasting for so many entries... oh man.. Quote Share this post Link to post Share on other sites
BIGAL 496 Posted Thursday at 12:35 AM You can select cells from excel "B12" can make a clipboard entry, not sure about the paste special from lisp. Are there a way copy and paste via clipboard by lisp? - AutoLISP, Visual LISP & DCL - AutoCAD Forums (cadtutor.net) Solved: Paste range of cells from Excel into AutoCAD table - Autodesk Community - AutoCAD LT Quote Share this post Link to post Share on other sites
