Nidhi210
New Member
I have two sheet.One contains Pivot table which has category name with different zone(North,East,West,South,CSD) and values in these zones category specific month wise.I need to copy this sheet with specific category to another sheet which has different sheets of category.Now I want code which can copy category from the Pivot sheet and paste value in sheet which has different sheet named based on category.Also it should be zone specific as not every time the category contains each and every zone value,month wise.the category name should be identified based on the name in the destination sheet ,Any help will be highly appreciated.