Jump to content
neuri

Need help with linking to specific excel cells

Recommended Posts

neuri

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.

Share this post


Link to post
Share on other sites
BIGAL

Your profile says you have LT correct ? That may be a problem.

Share this post


Link to post
Share on other sites
neuri
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.

Share this post


Link to post
Share on other sites
BIGAL

Found a possible answer after googling.

 

Copy a cell in excel

Paste special in Autocad, choose link. 

Share this post


Link to post
Share on other sites
SLW210

Copy the cell(s) in Excel>Paste Special in AutoCAD>Paste Link>AutoCAD Entities>OK then place where desired.

Share this post


Link to post
Share on other sites
BIGAL

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 by BIGAL

Share this post


Link to post
Share on other sites
neuri

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..

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...