Forum Discussion
How to insert a cell reference into a link to another workbook when pulling data in?
I have a main workbook that I am using, and need to pull in data from other workbooks into various cells. I have a ton of other workbooks that I am pulling from, and going into each one is onerous,...
The problem is that the INDIRECT function that can be used to convert text strings to a reference, only works with references to another workbook if that workbook is open in Excel. If the other workbook is closed, INDIRECT returns #REF!
Since you have many other workbooks, having all of them open in Excel doesn't look like a viable option.
If possible, combine the workbooks into a single workbook.
Otherwise, you might use a macro to create the formulas for you.
- Yeah, INDIRECT was as close as I got to it working....unfortunately I cannot combine them. I'll have to try a macro as a next attempt; I wanted to ask here first to make sure I was not missing something obvious.
