Hi Guys,
Question:
I need to gather the values of the exact same cell but from 30 different workbooks.
Say the cell is 'Activities'!A1
The path of the workbook is 'D:\Documents and Settings\administrator\My Documents\[sales 2006.xls]Activities'!A1
But how do I create a formula that pickes up the Excel file name from a particular cell.
Thus:
='D:\Documents and Settings\administrator\My Documents\[B1]Activities'!A1
Thanks
Michiel
Question:
I need to gather the values of the exact same cell but from 30 different workbooks.
Say the cell is 'Activities'!A1
The path of the workbook is 'D:\Documents and Settings\administrator\My Documents\[sales 2006.xls]Activities'!A1
But how do I create a formula that pickes up the Excel file name from a particular cell.
Thus:
='D:\Documents and Settings\administrator\My Documents\[B1]Activities'!A1
Thanks
Michiel