+ Reply to Thread
Results 1 to 3 of 3

Consolidating Worksheets

  1. #1
    Registered User
    Join Date
    08-28-2008
    Location
    Sault Ste. Marie, Ont
    Posts
    3

    Consolidating Worksheets

    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!??

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    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.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Populate data to different worksheets
    By leopardhawk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-06-2008, 09:05 PM
  2. Consolidate data from rows in many sheets to summary sheet?
    By Dynelor in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2008, 07:34 PM
  3. Deleting worksheets, printing to Adobe, and moving to a new workbook
    By baconcow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2008, 10:03 AM
  4. Consolidating data from multiple worksheets
    By pavemar in forum Excel General
    Replies: 2
    Last Post: 01-21-2008, 10:43 AM
  5. Selecting worksheets in a workbook based on criteria
    By josnah in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2008, 10:47 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1