Mia,

You can create a table of formulas that will sort your data based on a ranking that you devise: put
a column of RANK functions as the first column of your data, and key your VLOOKUPs to that column to
extract (and sort) the data automatically.

You can also use the worksheet change event to sort your data whenever cell A1 is changed.


HTH,
Bernie
MS Excel MVP


"Mia" wrote in message
...
Hello,

I want to have a totaly automatic macro. With that I mean that everytime i
change
in cell A1 the macro should run. What I´m trying to do is a tabel that will
automatic
sort after changed parameters. Do anyone know how to do this?
I´l be wery grateful!

BR
Mia