Hello All,
I am on Windows using Excel 365. I have a small spreadsheet that encompasses A3:E80. I have a header row in Row 3 and my data starts in Row 4. I would like VBA code to auto-sort this spreadsheet anytime a change is made to Column D (or specifically D4:D80). When it auto-sorts, I would like it to apply the following multiple sort order: Column D in descending order, Column A in ascending order, and Column B in ascending order. I have a macro that will sort the way I want it to but I can't seem to marry it with a worksheet change event. Been working on this for a little while now with no success. Any help on this would be appreciated!
I am on Windows using Excel 365. I have a small spreadsheet that encompasses A3:E80. I have a header row in Row 3 and my data starts in Row 4. I would like VBA code to auto-sort this spreadsheet anytime a change is made to Column D (or specifically D4:D80). When it auto-sorts, I would like it to apply the following multiple sort order: Column D in descending order, Column A in ascending order, and Column B in ascending order. I have a macro that will sort the way I want it to but I can't seem to marry it with a worksheet change event. Been working on this for a little while now with no success. Any help on this would be appreciated!