Forum Discussion
Auto sort help needed
Hi All- I have a spreadsheet where I want it to sort by status, column J, but I would like it to auto sort so anytime I add a new candidate the sheet automatically updates the sort when I add their s...
Lizzasso I noticed that your table in Sheet1 (it was called Table6) was set-up to cover all rows for columns A to M and that you had the filter buttons hidden. Let the table only contain "used rows", and unhide the filter buttons. Now after you made a few new entries, press the filter button and choose the sorting option you want. Why "pollute" your schedule with VBA code that basically does what a simple click on the filter button can achieve. Especially when you have never used VBA.
Made some changes to your file. See attached.