+ Reply to Thread
Results 1 to 6 of 6

Export Filtered Pivot Table Results (visible only)

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2019
    Posts
    3

    Export Filtered Pivot Table Results (visible only)

    Hello everyone,

    I am trying to export a list of filtered results from a pivot table. I have tried .visible .visibleitems, but I keep getting all 10 rows, instead of the 5 from the filtered pivot table that I want.

    I have attached an image that shows the data and pivot table. Thanks in advance.

    Here is the VBA...
    Please Login or Register  to view this content.
    datafrompivot.png
    Attached Files Attached Files
    Last edited by focusst; 07-27-2020 at 06:35 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Export Filtered Pivot Table Results (visible only)

    Your profile indicates you are using xl2003 yet you have uploaded a file that indicates a later version. Please update your profile to indicate the correct version you are using. Solutions may vary based upon your version. We want to give you the most effective and efficient solution.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    07-02-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2019
    Posts
    3

    Re: Export Filtered Pivot Table Results (visible only)

    Thank you. Been a while since I have been on. I have updated my profile to version 2019.

  4. #4
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    Re: Export Filtered Pivot Table Results (visible only)

    Maybe something like this ?
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-02-2013
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2019
    Posts
    3

    Re: Export Filtered Pivot Table Results (visible only)

    I think your position of "Valued Forum Contributor" is an understatement. Thank you so much! That worked perfectly.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Export Filtered Pivot Table Results (visible only)

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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: 1
    Last Post: 06-08-2020, 07:57 PM
  2. Histogram on filtered table, results only on filtered rows
    By Cheesecube in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 03-25-2018, 03:54 AM
  3. Export Data Excel (Text) into Ms Word Only Filtered - Visible Only
    By Jhon Mustofa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2017, 07:53 PM
  4. [SOLVED] Selecting the first x visible rows of a filtered table
    By DreamEyes in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-27-2017, 11:05 AM
  5. How to Reduce Filtered Results in Pivot Table?
    By clayjm in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-19-2015, 04:42 PM
  6. Pivot table to refresh and source data to change using visible rows on a filtered sheet
    By papasmurfuo9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-27-2014, 11:32 AM
  7. Pivot table not showing filtered results
    By Dan.Reynolds in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-28-2013, 02:09 PM

Tags for this Thread

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