I have a sheet listing workbooks in column A, what i want to do is extract data from the same cell in each workbook
ie
=[Book1.xls]Sheet1!$D$5
=[Book2.xls]Sheet1!$D$5
Is there a way to format the Sheet name cells so they can be added to that formula, an extract function or does it have to be done by VB ?
nb: there are 2000+ Worksbooks that i need to extract the data from an identical cell (D5)from
Cheers
ie
=[Book1.xls]Sheet1!$D$5
=[Book2.xls]Sheet1!$D$5
Is there a way to format the Sheet name cells so they can be added to that formula, an extract function or does it have to be done by VB ?
nb: there are 2000+ Worksbooks that i need to extract the data from an identical cell (D5)from
Cheers