+ Reply to Thread
Results 1 to 4 of 4

automatically create tabs for every value in a pivot table

  1. #1
    Forum Contributor
    Join Date
    02-27-2020
    Location
    Rotterdam, The Netherlands
    MS-Off Ver
    2013
    Posts
    171

    automatically create tabs for every value in a pivot table

    Hi,

    I have made a pivot table with two columns, one with customer names and one with amounts of money to be invoiced. If i click on a cell containing an amount of money, excel automatically adds a tab for that customer containg all the data that could also be displayed in the pivot table. This is a very useful option, but it takes time to click on every single cell in the second column to create each tab for every customer. Is there a way to automatically do this?

    Any input is much appreciated!

  2. #2
    Registered User
    Join Date
    10-14-2020
    Location
    Shanghai
    MS-Off Ver
    O365
    Posts
    32

    Re: automatically create tabs for every value in a pivot table

    Hi

    look for pivottable show report filter pages
    In tab PivotTable Analyze go to Option (PivotTable), then select Report Filter Pages.

    You need to have an item in the Filter area of the pivottable, otherwise it will be grey and can not be selected.

    This will create one new sheet for each item of the filter,

  3. #3
    Forum Contributor
    Join Date
    02-27-2020
    Location
    Rotterdam, The Netherlands
    MS-Off Ver
    2013
    Posts
    171

    Re: automatically create tabs for every value in a pivot table

    Thank you for your reply. Unfortunately the option "report filter pages" is greyed out and can't be selected. Do you happen to know how to be able to use this option?

  4. #4
    Registered User
    Join Date
    10-14-2020
    Location
    Shanghai
    MS-Off Ver
    O365
    Posts
    32

    Re: automatically create tabs for every value in a pivot table

    Quote Originally Posted by hansolu View Post
    Hi
    You need to have an item in the Filter area of the pivottable, otherwise it will be grey and can not be selected.
    Thats what i was writing if you read my post. There is another setting in the options of Excel which could cause the greyed field. Dont know by heart what exactly, but easy to find if you search for it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  2. Excel to automatically format a text file and create tabs
    By nikesone in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2015, 03:11 PM
  3. Trying to automatically create multiple sheets for each filter on pivot table.
    By Onek2fok in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2015, 11:35 AM
  4. Need to merge 2 tabs into 1 spreadsheet to create pivot table
    By nav2kz in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-11-2014, 01:00 PM
  5. Create additional tabs automatically based on input from master sheet
    By davidshluger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2010, 12:02 PM
  6. Help: Create Pivot Table from multiple tabs in a Spreadsheet
    By AUDIOBLASTER in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2007, 12:30 PM
  7. [SOLVED] How do pivot table source fields automatically create tabs
    By Datamonkey in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-25-2006, 01:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1