+ Reply to Thread
Results 1 to 2 of 2

2 Step Condition for Hiding Rows

  1. #1
    Registered User
    Join Date
    07-21-2023
    Location
    Canada
    MS-Off Ver
    Office Version 2205
    Posts
    1

    2 Step Condition for Hiding Rows

    Hello,

    New to VBA and sure if this is possible; not even sure what to query for help online.

    I have been tasked with automating an invoice tracker that uses characters instead of numbers. It really is more of checklist, where a unique character is entered each month to indicate if a customer was billed or not (eg: X = No Invoice Sent | √ = Invoice Sent | D = Draft prepared | etc.). I would like for rows to automatically hide if a particular character is entered into the "current month" column, so that I can determine what invoices are still outstanding by process of elimination. It is important to preserve the historical data however so I can see if an invoice was sent last month, 2 months ago, etc.

    The historical data is what is confusing me, because I am not sure how to write something that only checks the "current month", because there are recurring characters. I have created a list based on the table headings so I can select the current month I am working on....and this is where I am stuck.

    I am looking to:
    1. match/index the current month selection list to the corresponding table column
    2. check the data under the current month column (within the table)
    3. hide the entire row of the table if a character has been entered into the current month cell

    For example, the current month selection is July 2023. A check mark (√) has been entered in the current month for Row 24, so the entire row should be hidden.

    If this is possible, I am assuming I can then create a button to undo the hiding so I can change the "Current Month Selection" and repeat this process each month.

    I've uploaded a screenshot of the data set that will hopefully clarify what I mean. Please disregard the formatting, it will be cleaned up once the work is finished.

    Thanks in advance
    Attached Images Attached Images

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: 2 Step Condition for Hiding Rows

    You're probably not going to get too many responses with just a screenshot.
    See the yellow section near the top of the page and please follow all the instructions.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

+ 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. Hiding rows based on condition
    By ahmadjumaa80 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-11-2022, 06:06 PM
  2. [SOLVED] Hiding Rows based on Condition
    By Navee138 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2021, 08:36 AM
  3. Step code hiding columns
    By dasyurus in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-03-2016, 10:28 PM
  4. [SOLVED] Hiding rows based on condition within another sheet
    By Impjegat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2013, 01:45 PM
  5. Hiding Excel rows on condition without using macro
    By deepakborse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2010, 08:52 AM
  6. Hiding Unhiding Rows based on Text condition
    By Winner_texas in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-11-2010, 11:54 AM
  7. [SOLVED] Hiding rows on condition
    By Catherine Bond in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-23-2006, 01:25 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