+ Reply to Thread
Results 1 to 1 of 1

Formula to copy pivot table results if match into master sheet

  1. #1
    Registered User
    Join Date
    05-23-2011
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2010
    Posts
    1

    Post Formula to copy pivot table results if match into master sheet

    Hi,

    I have been struggling with this problem for some hours now. I have a master sheet that contains a complete list of names; monthly totals and unique counts for each month. I would like to copy the pivot table values for each name to my master sheet. The only issue is that all the names may not be contain in pivot as the data varies on a monthly basis. I also run a code for unique count of name for each month that is also a field in the pivot (I have not included it in this example (if there are two or more entries for that name in the month, then it will count it once)).

    Appreciate your help . . .
    Attached Files Attached Files

+ 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