If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hidding rows when sorting
Hi all
I have a sheet, where I upload informaton - some rows are hidden (parts already in stock) So, when they sort by some coloumn, it shows all rows, and hides the one which does not match. Is there an event I can catch so I can hide even more? It is a file someone else made at some time, so: how do I add the sort option? WBR Sonnich |
#2
|
|||
|
|||
Hidding rows when sorting
"hides the one which does not match"
Sounds like you are filtering, not sorting. Gord Dibben MS Excel MVP On Tue, 1 Jun 2010 09:46:57 -0700 (PDT), jodleren wrote: Hi all I have a sheet, where I upload informaton - some rows are hidden (parts already in stock) So, when they sort by some coloumn, it shows all rows, and hides the one which does not match. Is there an event I can catch so I can hide even more? It is a file someone else made at some time, so: how do I add the sort option? WBR Sonnich |
Thread Tools | |
Display Modes | |
|
|