Consolidate data in multiple worksheets

  • Thread starter Thread starter dah
  • Start date Start date
D

dah

Hi,

I have a workbook with 26 worksheets. Each worksheet is for a pa
period. I want to create a summary sheet that consolidates all th
information in the multiple worksheets.

Each person in the company is listed with their total hours per pay an
amount of pay.

I need a total for each person and an overall total on a final summar
sheet.

Each worksheet is similar in what it includes but since employees com
and go, people are not always listed on the same row.

How might I accomplish this task?

Thank
 
If I under stand you right:

You can make another summarry page and then sum cells in differen
pages, then from that you can get the totals for the company as
whole.

It works alot better if everybody's name is in the same place on eac
page, also with some functions there is a limit on how many cells yo
can use, I have never hit the limit and I do big projects.

Regards
Kevi
 
Back
Top