Hello,
I am kind of new to Excel programming and am a bit in a pickle.
I have one sheet that contains a pivot table as as follows:
Column A: has the product names
Row 4: columns B:G have January 2009, H:M February 2009, etc
Row 5: column B: Product2009
C: Customer2009
D: Support2009
E: ProductBudget2009
F: CustomerBudget2009
G: SupportBudget2009
and then the same B:G repeat for the next few months from row 4
Then on the next sheet I have a table that is trying to populate a table with some of the data in the pivot table in Sheet 1. I need to be able to automatically match based on 1)Product, 2)Month 3)Category (i.e. columns B:G)
Does anyone have any idea how I can achieve that task? Your help is greatly appreciated!