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

Are you asking for a sort or a filter?

--

Regards,
Nigel




"Mia" wrote in message
...
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

I'm looking for a filter.

//
Mia

"Nigel" skrev:

Are you asking for a sort or a filter?

--

Regards,
Nigel




"Mia" wrote in message
...
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