Pivot Table Drilldown - different deleted columns, formatting depending on pivot table clicked.

[Legacy 422070]

Hi, this question is an expansion on a previous question which had an answer to drilldown a pivot table to hide or delete particular columns and apply formatting:
https://www.mrexcel.com/forum/excel...olumns-range-instead-table-7.html#post5003258

I need to get this working on two pivot tables on the same sheet (or could be different sheets if necessary). I need each to use a different table to decide which columns to delete and the formats required. I can get one pivot table working using the method at the beginning of this post but can't get two working independently. Please help!!!!

 

[jschaefer1976]

Hey Jerry,

You really helped me out with this Pivot Table Drilldown thread! Thank you!!!

I have a question about another VBA Code I have been trying to figure out. I wanted to see if you could help me out with this. I have a spreadsheet that I want to be able to be used as a scheduling tool. Every week a new data file comes out that will replace the previous weeks data. I want to add dropdown's to the schedule sheet. These dropdowns would have a Parent / Child relationship. Basically, you pick the office you are in. Now when you go to the employee dropdown, it only list the employees from that location. Once you choose an employee, now you can go to the customer dropdown and you will only see your assigned customers. Once you pick a customer, now you can go to the service request dropdown and you will only see the service request numbers for that customer. Once you choose an service request number, that auto populates the priority level for that customer. I hope this makes sense. If you would like to take a look at the spreadsheet, I can send it to you. Any help on this would be greatly appreciated! Thanks Jerry!