New to Excel, Auto sorting column from high to low as data is changed

[Newmacgeek]

Hello everyone, i am new to excel so please bear with me.

in excel where you can select a column and sort it from high to low, how can you get this to be done automaticly as the data changes?

Many thanks

 

[EPURON]

You can record a macro doing this:

Make a table with filters. Then add your data. After that go to the column and click the arrow down and click sort from A - Z. If this "data" is numeric then I'm sure there is a option for that aswell. If not then idk :P

 

[Newmacgeek]

Hello, thank you for your comment.

This does not seem to work, i get the message "unable to record"

I have little knowledge with Macros

Anymore thoughts?