1 min readfrom 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.

submitted by /u/tiredbee_
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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