Help with auto sort data

Hi guys,

I need help. I want to auto sort my data but despite adding in Macro it still does not auto sort it for me.
The thing is I want to auto sort the data in sheet 2 in ascending order according to the "lowest rate #", whenever I change the rates in sheet 1.

Below is my attached sample file.

I've tried using this macro in sheet 2 but it doesn't seem to auto sort the data for me whenever I change the rates in sheet 1.

Please Login or Register  to view this content.

Is there some error in the macro? Help is much appreciated. Thanks!

Hi,

Now that I'm able to do on the sample file, I started with my work file using the macro given but there seems to be an error.

Run-time error '9':
Subscript out of range

What does that means? What should I do? I've attached my work file below.