Hello Everyone,
I was wondering if anyone could help me out with the "programing" of a section of my macro.
I created a macro by recording a set of actions but hadn't realized that the sections I was changing were dynamic, meaning that some weeks the information is there, some weeks it's not.
What the macro does is basically take the raw data file and turn it into a pivot table.
When I run my macro the following error comes up in yellow on the Debugger:
Is there any way that I could program the macro to skip this section "Request my data" or any other sections if they're not present in the raw data and still complete the pivot table with the information that is present?
Thanks in advance for your help!
I was wondering if anyone could help me out with the "programing" of a section of my macro.
I created a macro by recording a set of actions but hadn't realized that the sections I was changing were dynamic, meaning that some weeks the information is there, some weeks it's not.
What the macro does is basically take the raw data file and turn it into a pivot table.
When I run my macro the following error comes up in yellow on the Debugger:
ActiveSheet.PivotTables("PivotTable3").PivotFields("Sub Category Name"). _
PivotItems("Request my data").ShowDetail = False
Is there any way that I could program the macro to skip this section "Request my data" or any other sections if they're not present in the raw data and still complete the pivot table with the information that is present?
Thanks in advance for your help!