Forum Discussion
external reference designated by cell value
I'm wanting to link to cells to a different workbook where the workbook name and worksheet name are designated by cell values. i.e. =A1 in workbook "Tango" and work sheet "Alfa" So this works =...
- wow, thanks, that works. thank you so much (I spent all day yesterday trying to work this out for myself) thank you
Harun24HR as I am now using the INDIRECT function this only works when the source workbook is open. Is there anyway to get this working without having the source open?
TimEnt006 I have the same issue. I am having better solutions with INDEX, but still not live. I need to have manually written the whole address to the workbook tab, and then I can by formula select a cell. But it would be more workable if I could also make as formula the filename, address, and workbook too.
