Hi,
I am new to this forum and I consider myself to be a beginner to Excel VBA.
I have a pivot table and what I would like to know is when clicking on a value in the pivot table, when the new "Show Details" sheet opens, I would like via VBA to accomplish the following in the new "Show Details" sheet (I would like this to happen when the sheet is created):
Hope someone can help me out...I've been at a loss for the last couple of days.
Thank you!
I am new to this forum and I consider myself to be a beginner to Excel VBA.
I have a pivot table and what I would like to know is when clicking on a value in the pivot table, when the new "Show Details" sheet opens, I would like via VBA to accomplish the following in the new "Show Details" sheet (I would like this to happen when the sheet is created):
- delete all rows that contain the value "Regular" in the column named "WT"
- delete entire columns of data that have a specific header name (e.g. delete columns with headers "Department", "Location", and "Wages".
Hope someone can help me out...I've been at a loss for the last couple of days.
Thank you!