Hello,
I am trying to create a task tracker for my team and am trying to create a macro that will add the date/name in when a task is selected from a dropdown in that same row, like below:
I want it to go Task Selected>name/date added. I also want to make sure that the date doesn't change once added to the sheet, is that possible? I am just starting out with VBA and have found similar examples but can't seem to tweak them properly to get what I am looking for. Thank you.
I am trying to create a task tracker for my team and am trying to create a macro that will add the date/name in when a task is selected from a dropdown in that same row, like below:
(add date) | (add name) | Task Selected |
I want it to go Task Selected>name/date added. I also want to make sure that the date doesn't change once added to the sheet, is that possible? I am just starting out with VBA and have found similar examples but can't seem to tweak them properly to get what I am looking for. Thank you.