Linking Spreadsheet Data
Linking Spreadsheet Data
(OP)
I have several excel sheets with section property information.
I want to be able to access this data using VLOOKUP or something similar by linking the data to a new spreadsheet. Any suggestions?
thanks, Dik
I want to be able to access this data using VLOOKUP or something similar by linking the data to a new spreadsheet. Any suggestions?
thanks, Dik





RE: Linking Spreadsheet Data
RE: Linking Spreadsheet Data
I use that type of thing for structural steel wide flange properties. I just put the table on a different page in my worksheet. I tried once to use a separate spreadsheet with the table. Its hard to keep dragging that extra file along to every directory and subfolder that your worksheet goes into. And the references to the file always seeme to get tangled up and end up with error messages about a missing file reference.
If the table is not huge, put it into the spreadsheet your working on.
regards,
chichuck
RE: Linking Spreadsheet Data
(note all my double-quotes are to set off from my text and would not appear on your screen)
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Linking Spreadsheet Data
I find this construction very helpful. Each individual spreadsheet can be a logical grouping of data with many spreadsheets. Then I link to a master spreadsheet to extract summary information from the individual spreadsheets. Lumping everything into one huge spreadsheet would make it much more difficult to oragnize/navigate.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Linking Spreadsheet Data
Dik
RE: Linking Spreadsheet Data
RE: Linking Spreadsheet Data
But many of us prefer to use a spreadsheet. I have many "Linked" spreadsheets and all work well. I even link to Microstation, although only once. However, I slightly recall using a pivot table to help with the link issues of the past. I cannot fully remember why what or how but that may still be an option for linking diff. files.
Good Luck with it all! Moving files can be a pain.
RE: Linking Spreadsheet Data
br/
RE: Linking Spreadsheet Data