Merging Workbook Data
 

I have a number of team workbooks which each contain a summary sheet of data.
I want to create a new workbook for all the teams that takes and merges the
summary sheets from each workbook to a larger summary sheet of all the teams
in the new workbook. The format will be the same.

Is there an easy way to do this or do we need to write a Macro????

Merging Workbook Data
 

Hi Lee

For a macro look here
http://www.rondebruin.nl/copy3.htm


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



"Lee" wrote in message ...
I have a number of team workbooks which each contain a summary sheet of data.
I want to create a new workbook for all the teams that takes and merges the
summary sheets from each workbook to a larger summary sheet of all the teams
in the new workbook. The format will be the same.

Is there an easy way to do this or do we need to write a Macro????