Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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.


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,123
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Generating a dynamic monthly summary sheet based on weekly data sh Demand Planner Excel Discussion (Misc queries) 2 January 24th 08 02:14 PM
Summary sheet for multiple worksheets JohnnieBoy Excel Discussion (Misc queries) 1 October 30th 06 05:41 PM
Creating A Summary Sheet With Information From Several Worksheets Tim Leleux Excel Discussion (Misc queries) 4 March 16th 06 10:52 AM
How do I read info from different worksheets into a summary sheet? Waterh2o Excel Worksheet Functions 3 December 15th 05 09:01 AM
Summary sheet for 80+ tabs/worksheets Corey Excel Discussion (Misc queries) 2 November 18th 05 05:28 PM


All times are GMT +1. The time now is 05:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"