Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel
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? |
#2
|
|||
|
|||
If K is your last column, put this formula in cell L3 and copy it down
=COUNTIF(H3:K3,"")=4 Then filter on column L = True Beware that it will show false if there are any cells containing only spaces "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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |