+ Reply to Thread
Results 1 to 2 of 2

Display pivot table info on a seperate sheet.

  1. #1
    Registered User
    Join Date
    05-04-2020
    Location
    Falkirk, Scotland
    MS-Off Ver
    Office 365
    Posts
    3

    Display pivot table info on a seperate sheet.

    Hi all,

    See how with a pivot table you can then make a graph & slicers that show specific info. Is it possible that instead of a graph, can I make a table that is linked to the pivot table (still using slicers). The info I'm wanting to show is text, not numbers, hence the graph being a bit pointless.

    Cheers.

    If needed, I can make a small example of the workbook.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,422

    Re: Display pivot table info on a seperate sheet.

    I can't visualize why you would need to make a table from a pivot table that is filtered using a slicer. It seems as if once the filtering process is applied you could use the pivot table for the table you are looking for.
    Perhaps uploading a small example would help us better understand.
    Instructions for uploading are provided in the banner at the top of the page
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] Display pivot table detail in pre-named sheet
    By spyac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2018, 01:53 PM
  2. Replies: 6
    Last Post: 06-10-2013, 11:28 PM
  3. [SOLVED] Input summary info into a seperate sheet where multiple criteria are required
    By Anthem12 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-07-2013, 12:11 PM
  4. Replies: 3
    Last Post: 11-09-2012, 09:41 PM
  5. Using Macros - info from sheet go into a Pivot Table - how Can I hide the Pivot Table?
    By traceylreed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2012, 09:54 AM
  6. [SOLVED] filtered info can be copied (extracted) to seperate sheet
    By Fam via OfficeKB.com in forum Excel General
    Replies: 1
    Last Post: 04-21-2006, 08:15 AM
  7. [SOLVED] Master spread sheet to manage then show info on seperate tabs
    By Little pete in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-25-2006, 10:30 AM

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