Hidding rows when sorting

[jodleren]

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

 

[Gord Dibben]

"hides the one which does not match"

Sounds like you are filtering, not sorting.


Gord Dibben MS Excel MVP