Sorting makro

[Mia]

I´m trying to make a automatic makro for sorting. I have a list that will be
larger and larger so the range in rows should not be static. In one cell
(H7)I want to write the sorting criteria. For exampel If I write 1234 only
the 1234 numbers in kolumn 9 should be seen. Also I want this to work
automaticly, no bottom to press to start the maco, only write in the cell and
the sorting should change. Is there anyone who know hove to do this?

BR
Mia

 

[Nigel]

Are you asking for a sort or a filter?

 

[Mia]

I'm looking for a filter.

//
Mia

"Nigel" skrev:

Are you asking for a sort or a filter?

--

Regards,
Nigel
(e-mail address removed)