Consolidated Excel Sheet

[RJ]

Hi All,

I have many files namely:
AB.xls
AA.xls
RJ.xls
CF.xls Etc...Etc...
The 1st sheet of each file contains the Time report and the 2nd Sheet
contains the expense report.
Is there any way obtain a single long sheet with all the reports of
different persons in one single sheet(Consolidated one).

Thanks for any help!!!

 

[Ron de Bruin]

Hi RJ

Start here
http://www.rondebruin.nl/copy3.htm