Auto-Sort

[ckirkwalsh]

I'm looking for VBA code that will automatically sort (descending) my spreadsheet (with the exception of rows 1 and 2) on the contents of Column A whenever any value is changed in any cell in Column A. (It doesn't matter to me whether or not the column will sort when A1 or A2 are changed, as long as those rows are not moved in the sort).

Attached is an example. The actual sheet will look very similar with hundreds more entries. The first sheet is pre sort, the next is what I want the sheet to look like after one sort and the third after a second sort. You can see that I'm changing an entry in column A from 1 to 0, and want that entry to go to the bottom of the list. Obviously I want all the formulas to remain the same.

Thanks!

[protonLeah]

Does this work for you?

Please Login or Register  to view this content.

[ckirkwalsh]

Thanks!

I have run into another problem though . . .

I realize that I actually don't want to sort based on a column that I will actually be inputting.

Column 1 is going to come from another sheet (labeled Master in the example attached). But I want to sort when it is changed in the destination sheet (position 1).

I appreciate any help you have to offer!