ads_3131
11-22-2011, 02:30 AM
Hi all!
I need help with the following:
I have a list of names of workbooks in column A1 to A7
I then have the following example code in C1 to C7.....
='C:\test\[2011.xls]Sheet1'!B49
this looks up the location, workbook name, sheetname and the reference of the cell.................to finally show the value In my current spreadsheet from that spreadsheet......
Trying to explain the best i can :/
So what im asking for help with is ... instead of manually inputting the workbook name into my function e.g (2011) , how can i reference that to cell A1 to take the value which already has the workbook name.....
ANY HELP WOULD BE GREAT !
I need help with the following:
I have a list of names of workbooks in column A1 to A7
I then have the following example code in C1 to C7.....
='C:\test\[2011.xls]Sheet1'!B49
this looks up the location, workbook name, sheetname and the reference of the cell.................to finally show the value In my current spreadsheet from that spreadsheet......
Trying to explain the best i can :/
So what im asking for help with is ... instead of manually inputting the workbook name into my function e.g (2011) , how can i reference that to cell A1 to take the value which already has the workbook name.....
ANY HELP WOULD BE GREAT !