select everything
record a macro

<data<filter<autofilter
in H,I,J and K select "non blank" at the bottom of the list
stop recording.
make a figure or button and right click on it assign macro with the macro
name you just generated.

to show everything again go to <data<filter and select <autofilte again

"Kelly" wrote:

I am trying to hide rows in a sreadsheet. I have 150 stores running from A3
to A153. When they call in for an order I either put the quantities in H, I,
J or K. How can i set up a button to hide all rows that do not have data in
H, I, J or K?