Hey Friends!
I am trying to figure out a way to create a named worksheet from clicking a value in a Pivot Table. The default of excel, of course, is to create sheets with your detail you're requesting titled "Sheet1" and "Sheet2" etc... I would instead like it to name the sheet to whatever it is I am drilling into. In my situation, I am working with a company name, and then their invoice statuses. The hierarchy is as follows:
I would like to click on the 138, and instead of excel calling the sheet that shows me that detail "Sheet1", I would like it named something to the effect of "Firm A Denied".
Anyone know if this is possible? I appreciate the help in advance!
I am trying to figure out a way to create a named worksheet from clicking a value in a Pivot Table. The default of excel, of course, is to create sheets with your detail you're requesting titled "Sheet1" and "Sheet2" etc... I would instead like it to name the sheet to whatever it is I am drilling into. In my situation, I am working with a company name, and then their invoice statuses. The hierarchy is as follows:
- Firm A
- Approved................25
- Check Confirmed......3737
- Denied...................138
I would like to click on the 138, and instead of excel calling the sheet that shows me that detail "Sheet1", I would like it named something to the effect of "Firm A Denied".
Anyone know if this is possible? I appreciate the help in advance!