Auto-sort data which changes based on new data being input into another sheet

[analyst91]

Hi all,

I have data in the following form:

Region	Value	Volume
North	734198	3409
South	429837	8374
East	384209	1024
West	636412	3412

<tbody>
</tbody>

The data in this sheet is derived using a sumif() and countif() function on a separate sheet, and I'm trying to create a macro to auto-sort this data everytime a value changes. Any ideas how I can go about this, as any code I try seems to be dead?! (I insert the macro through the 'View Code' option as usual).

Many Thanks!

 

[Eric W]

Do you just have the 4 lines of data? If so, I'd recommend just using some LARGE formulas to auto sort them. Which column(s) are you sorting by? Do you need to account for ties?

The reason that your code seems to be "dead" may be because that after it sorts the data, the way your formulas work they may recalculate afterward, giving the same numbers. If you copy and paste values to another location, your sort may work.