Hi,
I recorded a macro to format data, I then created pivot tables on separate sheets. When I run the macro the pivot table range moves out to blank columns. My way around this was to record another macro editing the ranges of each pivot table but this will be time consuming going forward to maintain. Have I missed something that is making the range move from a1:m1000 to d1:s1000 hence giving me blank columns and pivot tables not working? Many Thanks
I recorded a macro to format data, I then created pivot tables on separate sheets. When I run the macro the pivot table range moves out to blank columns. My way around this was to record another macro editing the ranges of each pivot table but this will be time consuming going forward to maintain. Have I missed something that is making the range move from a1:m1000 to d1:s1000 hence giving me blank columns and pivot tables not working? Many Thanks