Auto sort multiple fields using macro

[Fixa]

Hello,

A am trying to set up a priorities based task list. The point is that it should put priority rate at different tasks and sort them top to bottom based on that.
I've managed to get the rates, but I am having problems setting up a macro that would apply the sorting each time new data is added.
Attached you can see a sample from the table. The table is being sorted by priority, then by importance, then by urgency.
Can you please suggest to me a macro that would apply that filters every time new data is entered.

Thank in advance

[Fixa]

Hello again,

I managed to get the auto filtering via VBA.
Can you guys please suggest me how to upgrade a bit the code. What I don't like is that cells remain select after each refresh. Can you please advice me how to evade that.

Thanks in advance,

Please Login or Register  to view this content.