Weekly Worksheets from others merged into one summary sheet

  • Thread starter Assistant who needs help!
  • Start date
A

Assistant who needs help!

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.

(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to sum monthly or weekly reports into one report 2
Summarising information from different sheets in a summary sheet 2
Feed Data from Multiple worksheets to a Summary Worksheet 2
search and copy text from one sheet to others 4
Copying Worksheets From Different Workbooks using Marco 4
Group information from several worksheets into one worksheet 1
combining data from multiple worksheets into one 6
Automate Combine 2 Spreadsheets into two worksheets 5

Top