Summary of multiple workbooks in a directory

W

William Hamilton

Hi again, I have a bundle of workbooks, each one has a summary page.
These will all be saved in the same directory eventually. I would like
to have a worksheet that presented me all teh summary pages (ordered
alphabetically by one of he fields). Excel can trwal a directory for
all .xls and extract an area from a worksheet then order on a cell?

I am not sure where to start on this and a web search was not much help
so far.

TIA

W
 
W

William Hamilton

Thanks Frank, looks like a good resource. I will run through and see if
I can work out how they are doing it.

thanks for the lead

W
 
Top