='C:\Users\Workbook\File\[00100 - Filename.xlsm]Tab View'!$T$3
This is what I currently have to utilize information from another workbook source pulling specific cells from that source into a row that is labelled "00100" (think of this as a batch number where each batch has a number of attributes represented in the following columns). What I want is to be able to have "00100" in cell A2 and rewrite the above formula as:
='C:\Users\Workbook\File\[A2 - Filename.xlsm]Tab View'!$T$3
Clearly, this is impossible based on all my searching (Indirect is useless as there would be way too many files referenced to have them all open at the time, and when I write the formula using Concatenate it doesn't return anything but #Value). Therefore, I've changed tactics and found a new problem. The top-most formula does work, however the concern is that because there is a row of similar formulas that all point to the same workbook but different cell locations, there is a risk that they may become damaged with use. I will need to copy the entire row of these formulas and have to change their references individually to find the correct workbook file - and this will be used by others that may not understand this importance!
I'm pretty stuck and open to any suggestions on how to move forward. This is ultimately for taxes, so simply copy/paste errors would be difficult to swallow. Any help is greatly appreciated.
This is what I currently have to utilize information from another workbook source pulling specific cells from that source into a row that is labelled "00100" (think of this as a batch number where each batch has a number of attributes represented in the following columns). What I want is to be able to have "00100" in cell A2 and rewrite the above formula as:
='C:\Users\Workbook\File\[A2 - Filename.xlsm]Tab View'!$T$3
Clearly, this is impossible based on all my searching (Indirect is useless as there would be way too many files referenced to have them all open at the time, and when I write the formula using Concatenate it doesn't return anything but #Value). Therefore, I've changed tactics and found a new problem. The top-most formula does work, however the concern is that because there is a row of similar formulas that all point to the same workbook but different cell locations, there is a risk that they may become damaged with use. I will need to copy the entire row of these formulas and have to change their references individually to find the correct workbook file - and this will be used by others that may not understand this importance!
I'm pretty stuck and open to any suggestions on how to move forward. This is ultimately for taxes, so simply copy/paste errors would be difficult to swallow. Any help is greatly appreciated.
