Combining multiple spread sheets into one

[flaschman]

I have individual week spread sheets needing to be combined into one form for
year report.
This is weekly contributor reporting that needs to be an individual
reporting for year end report.
Is there a simple way to accomplish this?

 

[Ron de Bruin]

Hi flaschman

Try my add-in
http://www.rondebruin.nl/merge.htm

Or see the links to the VBA code examples

 

[Gord Dibben]

If by "spreadsheets" you mean "worksheets" within a workbook see Ron de
Bruin's site for code.

http://www.rondebruin.nl/copy5.htm

If you mean from separate workbooks into one workbook see Ron's code at

http://www.rondebruin.nl/summary2.htm


Gord Dibben MS Excel MVP