Unhide next row on button click

[Andrewgram]

Hi All,

I have an excel sheet which has about 5000 hidden rows. We've only used about 300 of them. We hide them because the color scheme of the first 5000 rows can be overwhelming when there's no data written. We use an autofilter to hide anything up to row 5000 that <> "No" in the "Completed" column. (Column S). This keeps everything else with no data on the screen much cleaner by showing rows 5000+ which keeps all the unused space white.

Currently, when I want to add a new line, I have to turn off the autofilter and scroll down 300+ lines to add the data.

Is there a way to make a button that looks at "S4:S5000" and unhides the first row it finds where S = ""
If there's a way to also make that S = "No" in the process, that would be fantastic.

Any help is greatly appreciated.

Thanks in advance!

[AlphaFrog]

Change the red range to the the range of cells you autofilter.

Please Login or Register  to view this content.