Greetings from fabulous Las Vegas Nevada
My project:
A pivot table based on 6 columns of data (Month, name, region, credit card, amount, description).
I have a procedure that creates it on button click and works fine.
Problem:
When new data is added to the bottom, the procedure must be ran again so the new data is included in the pivot table.
All the resulting sheet numbers are getting large. Any way to prevent this?? I have reviewed Dave’s OZGRID site regarding dynamic named ranges but have not been able to implement the concept. Will this be able to solve the problem if indeed it is a problem? Is there a limit on how high a sheet number can go?
Good on ya all
My project:
A pivot table based on 6 columns of data (Month, name, region, credit card, amount, description).
I have a procedure that creates it on button click and works fine.
Problem:
When new data is added to the bottom, the procedure must be ran again so the new data is included in the pivot table.
All the resulting sheet numbers are getting large. Any way to prevent this?? I have reviewed Dave’s OZGRID site regarding dynamic named ranges but have not been able to implement the concept. Will this be able to solve the problem if indeed it is a problem? Is there a limit on how high a sheet number can go?
Good on ya all