Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2010
    Atlanta, GA
    Thanked 0 Times in 0 Posts

    combining, merging, matching data from one WB to

    I have a list of ten accounts ("master list").
    In any given month only 3 or 4 accounts have any activity and I get an EXCEL file with just those 3 or 4 accounts and the activity.
    I need to add that activity data to the master list in a new monthly column in the row for that account.

    There has to be a very simple way to do this, I just can't find it.

    (If it were only ten accounts, I'd do it manually, but there are actually two zeroes behind the numbers above)

    running Win XP, EXCEL 2003 (old guy)

    Need an example??
    Attached Files Attached Files

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts
    I suggest changing the master setup to more the setup of the monthly file:
    Acct, Acct#, Sales, and then add a month/year and a year column.

    You can create a pivot table to get out the "summary" using a page field for the year if desired

    Attached Files Attached Files

Posting Permissions

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