Hi Steve

You can look here for code examples
http://www.rondebruin.nl/copy3.htm

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


"steve" wrote in message ...
I have 6 worksheets with the same information for different age groups, but I
want each branch to send me a summary sheets so that it it easy for me to
make a large overall summary of the company.

Is it posible to have a system where data from the 6 worksheets will
automatically save to the summary worksheet? (I only need some of the
columns of data in the summary)

Thanks
Steve