ExcelBanter - Consolidated Excel Sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Consolidated Excel Sheet (https://www.excelbanter.com/excel-worksheet-functions/38296-consolidated-excel-sheet.html)

Consolidated Excel Sheet

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"RJ" wrote in message ...
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!!!

All times are GMT +1. The time now is 05:43 PM.