How can I combine 4 worksheets into one worksheet that would cont.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a report for my group of 4 schedulers at work. I have created
4 worksheets with totals of calls for specific time periods and days. I need
to combine the 4 worksheets into one "all shedulers" worksheet, without
having to manually add up each scheduler and post in the "all shedulers"
worksheet. Thanks.
 
As an example: the syntax for a multiple sheet addition of
the same cells is:

=SUM('2003 Jan:2003 Dec'!B14)

This will sum all entries in B14 in the sheets between
2003 Jan and 2003 Dec. Note that punctuation very
carefully.

Adjust for your specifics.
 
Hi

you might like to have a look at the consolidation feature under data /
consolidate

Cheers
JulieD
 
You must log in or register to reply here.

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

Combining data from multiple worksheets into master worksheet 1
How to I combine excel worksheets? 6
How do I combine multiple worksheets into one worksheet? 1
Match & combine rows from 2 worksheets 6
merging data/worksheets 1
How to use multiple command button to copy user form data to multiple worksheet 0
combining data from multiple worksheets into one 6
Combining Workbooks 1

Back
Top