•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
VBA coding for organizing
I made up a task list for work and I want it to auto organize by date every time I add a new task (Column A: client, Column B: due date, Column C: description of task)
I have it set so I can click the drop down arrow at the top of column B to organize by date, but I’d prefer it do it automatically as soon as I type in/enter a new task.
I’ve tried ✨MANY✨ VBA codes but AI has failed me in this regard 😂 any advice or help is appreciated. Worst case scenario I leave as is and manually update each time I add a task.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#VBA
#coding
#Excel
#task list
#auto organize
#date
#due date
#Column A
#Column B
#Column C
#client
#description
#dropdown arrow
#sort
#automatic
#new task
#event trigger
#worksheet
#macro
#data organization