View Poll Results: .

Voters
0. This poll is closed
  • .

    0 0%
  • .

    0 0%
+ Reply to Thread
Results 1 to 3 of 3

Consolidating data from multiple worksheets

  1. #1
    Registered User
    Join Date
    04-24-2007
    Posts
    14

    Consolidating data from multiple worksheets

    I have data, by account and then department, for a few years. Each year is an entirely seperate report and I need to consolidate them all to one sheet so that I can do some sort subtotaling or pivot table that would give this data by department, then account, for each year.

    Data sets look like tabs FY07 and FY08 in the attached sample file. The 'Summary' tab is what I'm after, so that I could subtotal or pivot.

    Many thanks!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-23-2006
    Posts
    194
    The following may assist:

    http://www.contextures.com/xlPivot08.html

  3. #3
    Registered User
    Join Date
    04-24-2007
    Posts
    14
    many thanks, stephen.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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