[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

--

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


"flaschman" wrote in message ...
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?

[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

On Tue, 5 Jan 2010 13:07:01 -0800, flaschman
wrote:

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?