ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Compiling data from many work sheets to one (https://www.excelbanter.com/excel-discussion-misc-queries/150761-compiling-data-many-work-sheets-one.html)

justme

Compiling data from many work sheets to one
 
I am trying to compile some data from many Excel workbooks to one workbook.
Ex, my payroll is entered weekly and contain project #'s, and employees. I
want to compile the project numbers and hours worked into one sheet. Any
suggestions would be appreciated.

Thanks

Ron de Bruin

Compiling data from many work sheets to one
 
Hi justme

You can start here
http://www.rondebruin.nl/copy3.htm

Maybe you like the add-in

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"justme" wrote in message ...
I am trying to compile some data from many Excel workbooks to one workbook.
Ex, my payroll is entered weekly and contain project #'s, and employees. I
want to compile the project numbers and hours worked into one sheet. Any
suggestions would be appreciated.

Thanks



All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com