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).
Thanks!
Hello ckirkwalsh,
I understand that rows 1 and 2 are not to be sorted. Due you want the sort to be triggered when any cell in column "A" changes? Do you have a sample workbook you can post?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith-
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks