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?

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" <(E-Mail Removed)> wrote in message news:A9F6BC95-9CC9-405A-BEF6-(E-Mail Removed)...
>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?
>

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
<(E-Mail Removed)> 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?