+ Reply to Thread
Results 1 to 5 of 5

Hide rows with a partcualr criteria from a pivot table

  1. #1
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275

    Hide rows with a partcualr criteria from a pivot table

    Hi Brains its me again

    Gradually working through the filters of the sheet but need it now to hide any load beginning with 003. The column in question is incorporated in a pivot table.
    Im thinking this code hides anything with 003 in it not just loads beginning 003. Each load number is 10 digits long

    Please Login or Register  to view this content.
    Last edited by ukphoenix; 05-24-2020 at 01:39 PM.

  2. #2
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275

    Re: Hide rows with a partcualr criteria from a pivot table

    ok worked it out. Any elaboration on this code please add

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275

    Re: Hide rows with a partcualr criteria from a pivot table

    Quote Originally Posted by ukphoenix View Post
    ok worked it out. Any elaboration on this code please add

    Please Login or Register  to view this content.
    OK SO NOT RESOLVED.
    Im guessing the issue is "003 " as everything else seems to point in the right direction. So this needs to look at all 10 digit numbers beginning 003 and hide the row

  4. #4
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275

    Re: Hide rows with a partcualr criteria from a pivot table

    Can anyone help with this resolve. Its probably something so simple im gonna kick myself

  5. #5
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    Office Pro 2010
    Posts
    275

    Re: Hide rows with a partcualr criteria from a pivot table

    OK issue not resolved but possibly another option to replace.

    ADMIN CAN YOU CLOSE THIS POST

+ 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. PIVOT TABLE - Hide Blank Rows
    By Rangerguy2000 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-02-2019, 12:09 PM
  2. Hide pivot table columns based on date criteria
    By boontz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-16-2014, 09:56 AM
  3. [SOLVED] hide rows, based criteria table
    By elsg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2014, 05:35 PM
  4. Pivot Table total rows hide?
    By EnergyEngineer in forum Excel General
    Replies: 3
    Last Post: 04-29-2008, 02:56 PM
  5. PIVOT TABLE: Hide All Fields (without specific criteria)
    By wealthistime in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2007, 01:54 PM
  6. [SOLVED] How do I hide rows in a pivot table with zero values?
    By fs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-22-2006, 04:15 PM
  7. Pivot Table - How to hide all rows which is 0
    By Ctech in forum Excel General
    Replies: 2
    Last Post: 05-03-2006, 08:56 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