Hello Team,
I have more than 50 work sheets in my workbook, I want to insert pivot table for each sheet, I have unique column name named charge description in each sheet, so need a VBA code or any other help to insert the pivot table for each individual sheet at once instead of manually inserting pivot table for each sheet. On rows I need charge description and on values I need count of charge description.
Note- the given unique column name "charge description" will be in different columns on each sheet.
Kindly check and do the needful. Thank you.
I cant attach the excel since it is more than 40MB.
I have more than 50 work sheets in my workbook, I want to insert pivot table for each sheet, I have unique column name named charge description in each sheet, so need a VBA code or any other help to insert the pivot table for each individual sheet at once instead of manually inserting pivot table for each sheet. On rows I need charge description and on values I need count of charge description.
Note- the given unique column name "charge description" will be in different columns on each sheet.
Kindly check and do the needful. Thank you.
I cant attach the excel since it is more than 40MB.
