Variable Link to Workbooks
I want to link mulitple workbooks in to one, is there a way to make the link
a variable formula so I can have the workbook names across the top of my spreadsheet and use those in the link. This way I can just change the workbook name on the top of the column and the data would change. I tried using the INDIRECT formula but I get a #REF... I use the Indirect formula now but not in a link to another workbook... HELP !!!! -- Dave F |
Harlan Grove wrote a User Defined Function that can pull from a closed
workbook: http://groups.google.co.uk/groups?se...wsranger.co m If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm dfrancefort wrote: I want to link mulitple workbooks in to one, is there a way to make the link a variable formula so I can have the workbook names across the top of my spreadsheet and use those in the link. This way I can just change the workbook name on the top of the column and the data would change. I tried using the INDIRECT formula but I get a #REF... I use the Indirect formula now but not in a link to another workbook... HELP !!!! -- Dave F -- Dave Peterson |
All times are GMT +1. The time now is 04:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com