J
Joe
I want to programmically extract certain information from all workbooks in a
folder, always in the same place on the same sheet in each workbook.
The result will look like this:
Bookname Sales Profit
Book1 999 999
Book2 999 999
etc.
assuming Sales and Profit are in cells c10 and g10 of the sheet named "P&L".
folder, always in the same place on the same sheet in each workbook.
The result will look like this:
Bookname Sales Profit
Book1 999 999
Book2 999 999
etc.
assuming Sales and Profit are in cells c10 and g10 of the sheet named "P&L".