+ Reply to Thread
Results 1 to 3 of 3

Print out from filters on table

  1. #1
    Forum Contributor
    Join Date
    05-13-2013
    Location
    Swindon UK
    MS-Off Ver
    Excel 2010
    Posts
    277

    Print out from filters on table

    I have a spreadsheet with some filters, when I click on the filter to filter all say name 7 all the information in relation to that name will pop up and then I can print out the document for that user, no concerns here.

    However, if I want to print out a document for like 2 or more user then I have to do this separately, and this will take some time I have a lot of users to print out and need 1 sheet per person each sheet.

    Is there a way that I can click all the names so that I can print out all their information on their own sheet, is there a macro that I can use

    I have taken names out and replaced with a number for obvious reasons

    Hope someone can help
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-13-2013
    Location
    Swindon UK
    MS-Off Ver
    Excel 2010
    Posts
    277

    Re: Print out from filters on table

    Hi, would really appreciate some help on this is if anyone can help

    Thank you guys,

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

    Re: Print out from filters on table

    Maybe producing a pivot table and then using the Pivot Table Analyze option > Show Report Filter Pages would do what you want.
    1. Add a new column, Name 2, to Table1 which could be populated using: =C3
    2. Produce a pivot table using the original fields in the Rows area and the Name 2 field in the Filters area
    3. Utilize the information in the linked video tutorial which explains the process: https://www.youtube.com/watch?v=sjnUThSQ8hk&t=3s
    Let us know if you have any questions.
    Attached Files Attached Files
    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. VBA to loop through 1 pivot table filter & print, leaving 2 other filters alone
    By CamasFlowerPower in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2021, 12:54 PM
  2. Replies: 2
    Last Post: 12-08-2016, 11:48 AM
  3. Print Filters using Macros
    By aarbogast87 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-04-2016, 09:18 AM
  4. How to change and print multiple filters of a single pivot table at once?
    By hasselblad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2016, 04:26 AM
  5. Macro to print all pivot table filters but excluding blank pages
    By Hdim in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2014, 03:03 PM
  6. Replies: 0
    Last Post: 04-02-2014, 06:13 PM
  7. Change filters and print based off of a list
    By Pergo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2013, 04:15 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