Automatically Hide Rows in Excel Based on Multiple Conditions Based on a Cell Result

If you want to learn how to do this process in Google Spreadsheet, please watch the video below:

The full article of this demonstration and the formula used are now posted on our website, please click the link below:

And if you want to be a Full Fledge Member of our Team, please join the link below.

Please help us keep our channel going!!!

Please show your support to our Channel by donating any small amount to keep our projects going, you can send your donations to:

Bank Transfer:
Landbank of the Philippines Account
Account Name: Wedzmer B Munjilul
Account Number: 0165 0409 29

Unionbank Account
Account Name: Wedzmer Briz Munjilul
Account Number: 1094 2956 4720

GCash: [phone]

Even a P1.00 donation goes far.

===========================================================

Details:

Link of previous tutorial about Automatic Hiding of Rows using VBA

Article regarding Hiding of Rows using VBA:

#Excel #VBA #Conditional

[closeuptrading]

appreciate the tutorial go it working, but how to unhide the rows after clicking the button, i thought by clicking it again would do it, but did not, do i need another macro if i want the hidden cells to show

[archboyd]

Pretty good, it also hid the female row as well.

[TheRiddlerabz]

ok this doesnt unhide though does ? once i push the button, pressing it again does not unhide ??

[Jabz-]

When i closed my excel file and reopened it my macro script disappeared and the button no longer worked even though i saved the file before closing, any clues ?

[robincano]

I really learned from this tutorial. What will the code if I will unhide the hidden rows? I am hoping much of your reply. Thank you so much

[nk]

What is error 424 and its showing object required

[grisheldamarks-webster-noa]

Hello, How can I automatically hide rows based on a cell value without VBA codes? I can not use macros. Thanks

[vytalbusinessconsultants]

Hi, Thank you for sharing this tutorial...
A question, how to hide a row based on values in different cells of different columns...
e.g I want row #2 to automatically hide if cell B2 cell value is "O" or if cell C2 cell value is "P" or if cell D2 cell value is "Q" ...

[mangubatrechellec.]

What if you want to show it again? or need to unhide manually? thanks sir

[omek]

Hello my friend, thank you for the tutorial it was very helpful. is it possible to tell me how i can do this button to Hide and Unhide the rows ? with your commands i can hide them but i can not unhide the hidden rows

[aayushshrestha]

Run-Time error 1004?
And on clicking button ×400?

[ovakem]

You could simply multiply column1 * Column 2 and the result would be Zero if any of the columns were Zero, no need to write the "or" formula.

[TheRevlation]

I dont know when was this made... but he made a simple task complicated.
Just do this:
Select the whole range you want Filtered.
Go to DATA>Filter... or press Ctrl+Shift+L
Then filter according to your needs.... no formulas needed

[georgegonos]

You do a good job but spend too much time off subject. I am now at 9 minutes of the 13 in the video and you still have not told me how to auto-hide the rows. Instead, you spent well over half of the video teaching other on man! And, what's up with the annoying background music bro?