Hello,
I am trying to edit a macro with some pivot tables. I am extremely novice with VBA editing and I would be extremely appreciative of your help
. The macro creates a pivot table and grand totals for monthly data. Sometimes the grand total must be adjusted with filters. At times I need to filter out "(blank)" fields and other "credit" and "debit" fields. How can I filter these out of the pivot in the macro if they are present in the data and skip the filter if they are not so the macro runs without stalling. Attached is a photo of the fields that sometimes appear in the data. Thank you so much!
Imgur: The most awesome images on the Internet
I am trying to edit a macro with some pivot tables. I am extremely novice with VBA editing and I would be extremely appreciative of your help
. The macro creates a pivot table and grand totals for monthly data. Sometimes the grand total must be adjusted with filters. At times I need to filter out "(blank)" fields and other "credit" and "debit" fields. How can I filter these out of the pivot in the macro if they are present in the data and skip the filter if they are not so the macro runs without stalling. Attached is a photo of the fields that sometimes appear in the data. Thank you so much!Imgur: The most awesome images on the Internet
