Good morning:
I'm looking for help on copying data from a pivot table and pasting them to the appropriate cells on a separate worksheet based on 2 levels of matching criteria.
I've typically been using record macro and basic stuff like populating set values in a range if a cell is blank for example. This particular request is difficult for me as I'm not sure how to have the macro match the "1" and "2" with applicable sub categories i.e. 0-30 DAYS, 31-60 DAYS on sheet "DEF Pivot" with the like data from sheet "DEF Report". If it matches, I'd like the $ amount to copy/paste from "DEF Pivot" to the appropriate place on "DEF Report". Using record macro I can only get it to manually copy/paste things that I specifically select. The layout of "DEF Report" is constant and doesn't change. However, the layout of "DEF Pivot" as the "2" can be in a different column A cell and there can be more or less of those sub categories.
I've linked an image of the two worksheets showing what I'm talking about from a completed already pasted product:
I use Excel 2010 and Windows 7.
Hope this is explained well enough. Thank you.
I'm looking for help on copying data from a pivot table and pasting them to the appropriate cells on a separate worksheet based on 2 levels of matching criteria.
I've typically been using record macro and basic stuff like populating set values in a range if a cell is blank for example. This particular request is difficult for me as I'm not sure how to have the macro match the "1" and "2" with applicable sub categories i.e. 0-30 DAYS, 31-60 DAYS on sheet "DEF Pivot" with the like data from sheet "DEF Report". If it matches, I'd like the $ amount to copy/paste from "DEF Pivot" to the appropriate place on "DEF Report". Using record macro I can only get it to manually copy/paste things that I specifically select. The layout of "DEF Report" is constant and doesn't change. However, the layout of "DEF Pivot" as the "2" can be in a different column A cell and there can be more or less of those sub categories.
I've linked an image of the two worksheets showing what I'm talking about from a completed already pasted product:
I use Excel 2010 and Windows 7.
Hope this is explained well enough. Thank you.
