+ Reply to Thread
Results 1 to 3 of 3

Print Button that removes columns before printing from custom pivot table filter

  1. #1
    Registered User
    Join Date
    12-30-2015
    Location
    Toronto
    MS-Off Ver
    2013
    Posts
    2

    Print Button that removes columns before printing from custom pivot table filter

    Hi All,

    I have a dashboard that pulls from a sql database, we use filters to select what data the user would like to see, they select a company/companies and dates that they want to pull data for. Currently we have a print button that takes the custom data requested, formats it, and launches the print set-up.

    What i am trying to do is have the print button remove specific columns so that i can change the print from landscape to portrait. There is unnecessary data that does not need to be printed causing clutter and forcing us to print landscape.(it is how ever valuable for internal clients to see, but not external)

    Currently the code selects a range for the column and rows (as the amount of rows can change depending on user selection), so i am not sure how complicated it would be to do this.

    Anyone have any ideas?

    Your help is much appreciated

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Print Button that removes columns before printing from custom pivot table filter

    Hi and welcome to ExcelForum,

    You might want to download the sample file asssociated with post #2 in the following thread. Example 4 solves a similar problem. http://www.excelforum.com/excel-prog...ml#post4274823

    Lewis

  3. #3
    Registered User
    Join Date
    12-30-2015
    Location
    Toronto
    MS-Off Ver
    2013
    Posts
    2

    Re: Print Button that removes columns before printing from custom pivot table filter

    Thank you lewis.

    Will try now and let you know what happens.

+ 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. EXCEL VBA - Print PDF - removes the active filter before printing
    By umeshbanga in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2015, 03:19 AM
  2. Can you add columns with custom formulas in a pivot table?
    By JosieJo112 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-13-2014, 05:45 AM
  3. [SOLVED] Use A Custom List of Values To Filter Pivot Table
    By dollylectric in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-29-2013, 01:05 PM
  4. Creating a Custom Pivot Table Report Filter
    By csivell in forum Excel General
    Replies: 0
    Last Post: 08-08-2012, 02:21 PM
  5. Custom order in Report Filter for Pivot table
    By papvan33 in forum Excel General
    Replies: 0
    Last Post: 04-20-2011, 04:50 AM
  6. Custom date filter for a pivot table in XL2007
    By IM2HARD2RESIST in forum Excel General
    Replies: 1
    Last Post: 12-03-2009, 01:10 PM
  7. Pivot Table hiding row removes from row !
    By Fullam in forum Excel General
    Replies: 1
    Last Post: 04-14-2006, 07:50 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