Automatic Sorting of Data

[mc2468]

Hi,

I was wondering if anyone could help me with the attached S/S example. I would like the S/S to sort in descending order the data by the % increase column (Column E) automatically when figures are entered into Column C.

Could anyone help me with a macro or VBA code that would achieve this.

Many thanks in advance

[humdingaling]

put this code in sheet 1

Please Login or Register  to view this content.

[NeedForExcel]

Hi,

Please see the attached file..

This is a basic Recorded Code.. See if it helps..

Note: The Code can be made much robust and neat.. Was feeling lazy to actually code it..

Ensure your macros are enabled

Cheers!

[mc2468]

Big thanks to both of you. Both your solutions did the trick.

Many thanks

[NeedForExcel]

Glad it helped!

Please mark the thread as solved if you have your answer..

Cheers!
Deep