Date for Task Tracker

[alexwoje]

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:

(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.

 

[alexwoje]

Another question sorry....I have to use the time tracker for two different teams. I've tried to copy the code from one workbook to the other, but when I run it on the second workbook it opens the first workbook. Is there any way to stop that from happening?

 

[Joe4]

Another question sorry....I have to use the time tracker for two different teams. I've tried to copy the code from one workbook to the other, but when I run it on the second workbook it opens the first workbook. Is there any way to stop that from happening?

Are you referring to the code I gave you?
There should be nothing in my code that would do that.

If you are referring to your other code, that is a whole different question and you should post that question to a new thread.