Consolidating Worksheets

**ctf** · 08-28-2008, 01:52 PM

Hi, I am trying to consolidated about 12 worksheets into one. Each worksheet is the month of the year and has the workers name and pay. While the final worksheet has all the months of the years in columns along with the employees name and pay for each month and a total at the end. The problem I am having is that some of the workers are in some months but not others. How would I consolidate them all onto the one yearly report. The cells from each seperate sheet need to be linked to the final yearly report. Any suggestions of how I could go about this!??

**royUK** · 08-28-2008, 04:36 PM

You need to attach a workbook showing your layout,, but you are really doing this the wrong way round. All data could be stored on one sheet with a column for month, then a PivotTable could be added to review the data.

**Leith Ross** · 08-28-2008, 04:48 PM

Hello ctf,

Welcome to the Forum!

Any answer given really depends on the layout of your data. From what you have described, I would say that you could a Pivot Table to generate your summary.

Here are few links you where you can learn more about them...

Introduction to Pivot Tables
Pivot Table Reports 101 - Microsoft Office Online
Basic Pivot Tables Tutorial in PDF format

Sincerely,
Leith Ross