- Mar 2, 2005
- 4,149
- 1
- 91
Hey peeps.
I have a problem I have been pulling my hair out about for a while.
I am looking for a way to take a reference from another file that is constructed from inputted cell references.
I found a way to do this with INDEX, but for some reason, INDEX only works when the other workbook is open. I tried some other functions, but they do not seem to have any way to get a constructed text address into the input field.
What I want to be able to do is specify the directory, the file name and the tab with a fixed cell reference to be able to grab numbers from different sheets on different directories.
ANY help would be GREATLY appreciated!
I have a problem I have been pulling my hair out about for a while.
I am looking for a way to take a reference from another file that is constructed from inputted cell references.
I found a way to do this with INDEX, but for some reason, INDEX only works when the other workbook is open. I tried some other functions, but they do not seem to have any way to get a constructed text address into the input field.
What I want to be able to do is specify the directory, the file name and the tab with a fixed cell reference to be able to grab numbers from different sheets on different directories.
ANY help would be GREATLY appreciated!