•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pivot Table Report Filter Pages - Sheet Names
Hi everyone,
I am using Excel's Pivot Table Report Filter Pages to generate individual worksheets out of a list of accounting schedules. These schedules are numbered and have a name (description). Whenever I use the number as the filter, I obtain sheets with the schedule number as the name of the sheet. However, when I try filtering using the name (description), the sheets are named progressively as Sheet93, Sheet94. etc. Does anyone know what setting do I need to fix in order to obtain the name (description) as the name of the resulting sheets?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#google sheets
#Excel compatibility
#Excel alternatives for data analysis
#rows.com
#financial modeling with spreadsheets
#Pivot Table
#Excel
#Report Filter Pages
#individual worksheets
#filter
#accounting schedules
#name description
#schedule number
#worksheets generation
#resulting sheets
#sheets
#filtering
#filter number
#sheet names
#settings