What is the proper code if the title of your columns change? I am working on a manufacturing capacity outlook file that changes weekly. I need to have my column names in my pivot table change to the upcoming weeks.
So instead of: ActiveSheet.PivotTables(“PivotTable5”).AddDataField...