Automatically Hide/Unhide Rows Based on Cell Value, as that cells value changes

CheeseItzz

New Member
Joined
Aug 31, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Totals for the year:
1598889342500.png

Totals for March:
1598889320742.png


Hello Excel team!

Not sure if this is possible, but I'm wondering if rows can be hidden and un hidden in real time based on a specific value of the cell in that row. I say real time because that cells value will be changing per specific search criteria(s).

Pictured above is SHEET "Total". The data that is in column H in rows 6, 7, 8 is being collected from SHEET "Months"(not shown). "Months" has a table of information that can be filtered to show something specific. When I filter the data on SHEET "Months", the values in SHEET "totals" column H cells 6, 7, and 8 change to show me totals on what I am looking at specifically.

EX:
SHEET Months unfiltered show the values you see in PICTURE 1 for sheet "Total"
SHEET Months filtered to show only fruit in the month of March, the values become like PICTURE 2 for sheet "Total"

What I am trying to do is have any row(s) that show a value of 0 , like bananas above, to be hidden. BUT If I un-filter my search and the cell values change above 0 I want that row to un-hide.

EX:
SHEET Months is showing the month of March only so SHEET "Totals" row 7 "Bananas" should be hidden because there are no bananas in that month.
SHEET Months is unfiltered and in SHEET "Totals" the value of 350 is returned to cell H7, that row should now be unhidden and I should now see all three fruits

Obviously I'm using fruits to protect data on my project lol. On my totals sheet I have 300 rows of product and growing. I would like to be able to see only the product I need to based on my search for ordering and planning purposes. Thank you everyone for your help with this, even if its a simple answer.
 

Attachments

  • 1598888673124.png
    1598888673124.png
    22.7 KB · Views: 1
  • 1598888711714.png
    1598888711714.png
    22.7 KB · Views: 1

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,114,032
Messages
5,545,629
Members
410,696
Latest member
JTrehan
Top