Weekly Worksheets from others merged into one summary sheet
 

Hello!

Every Monday I recieve a worksheet from 10 different team members, about
there departments percentages, etc. I think manually take some data off those
sheets (which are all exact) and then enter it into another document,
"summary page".

I do this with mulitple reports and this takes many hours. Isnt there a way
for me to have this automatically inserted, or macros'd in?

I would like to avoid having to search for all these numbers on there docs
and manually enter them into my doc.

Can you help!? I am running MS Excel 2007.

Weekly Worksheets from others merged into one summary sheet
 

Hi

See
http://www.rondebruin.nl/mail/folder2/saveatt.htm

And then to merge see
http://www.rondebruin.nl/copy3.htm


--

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


"Assistant who needs help!" <Assistant who needs wrote in message
...
Hello!

Every Monday I recieve a worksheet from 10 different team members, about
there departments percentages, etc. I think manually take some data off those
sheets (which are all exact) and then enter it into another document,
"summary page".

I do this with mulitple reports and this takes many hours. Isnt there a way
for me to have this automatically inserted, or macros'd in?

I would like to avoid having to search for all these numbers on there docs
and manually enter them into my doc.

Can you help!? I am running MS Excel 2007.