Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Combine 2 tables with data from separate Fiscal years

    Hello, I must compare 2012 payment activity to 2013.

    Data is in in 2 columns that have the same heading, however, the list of funds have changed between the 2 years. Any suggestions on how to merge same info and add new ? I tried a pivot table and that didn't work.


    FY2013 Fund FY13 $
    556069 7,002.50
    558339 1,330.98
    553069 7,307.40

    FY2012 Fund FY12 $
    558339 3,230.98
    556069 19,970.04
    557069 18,164.96
    553733 952.00

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    AB,

    If this is what you're after:
    ab2537 - Pivot Table.PNG
    What I would do is add a column on each worksheet and enter the year into it for each entry.
    Then setup 3rd sheet and copy the data from the other two sheets one after the other.
    Then use a Pivot Table.

    Attached is an example file.

    HTH
    Attached Files Attached Files
    Last edited by RetiredGeek; 2013-01-29 at 15:54.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    ab2537 (2013-01-29)

  4. #3
    Lounger
    Join Date
    Mar 2006
    Location
    Philadelphia, PA
    Posts
    30
    Thanks
    12
    Thanked 0 Times in 0 Posts
    Yes!!! Thank you so much!!!

Tags for this Thread

Posting Permissions

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