Code to put today's date in empty cell dependent on selection from drop-down list

I'm a VBA novice looking for a solution to the following please:

I have a drop down list with 10 different options. Depending on which option is selected I would like today's date to be inserted in a different cell IF that cell is empty. If it's not empty then nothing should happen, the idea being that the date each option was selected will be stored permanently in the relevant cell.
So, to explain if "Briefed" is selected from the drop down list, I'd like the date to appear in cell M4 (if M4 is empty). If "Quoted" is selected from the list I'd like the date to appear in cell N4 (if N4 is empty) and so on and so forth for 10 options on the list.

Being a novice this is way above my head - any help anyone can give me would be hugely appreciated!

Many thanks

Vicky

Hi Solus

I have attached the workbook. The drop down list I'm referring to is Column F - Status. I'd like the date to be entered in the cells in Columns M:V on the same line as the selection.

Also I've realised I'll need the column G "Date" to reference the date that gets entered depending on selection. So if "Briefed" is selected in F4, cell G4 displays the data in M4. If "Quoted" is selected in F4, G4 displays Data in N4 etc.

Many thanks for your help!

Vicky

That mostly works great, thanks so much! Only problem is the onsite option doesn't add a date, and I've just noticed I didn't put a column in for the "Received" option.

I'm eager to learn some bits of code myself - would you mind explaining what each line/section does and I'll try to fix it myself?

Thanks again

That's great - I've fixed the glitches too with that information - really appreciate your help

Any chance you could give me a hint on how to display the relevant date for the selection in Column G please? Normally I would just paste a link but as it needs to change I'm a bit lost.

Thanks for this - I fixed the code to the following to include the Received option:

Please Login or Register  to view this content.

The on-site issue was a typo as they weren't spelled the same.

I can't get the new line of code to work but looking at it I'm not sure I explained myself properly.

I'd like the date shown in column G to reference the original date the item was selected, (the date columns to the right will be hidden from view to avoid clutter). So if at a later date somebody wants to see when the job was initially received they can do so by reclicking on the "Received" option and it will display the date shown in the column to the right. I hope I'm making sense, probably not!

Thanks

Thank you... Ideally I need Column G to change whenever the option in the drop down is changed. Is there a way to change which cell it references? Should I post this as a new thread as it seems like a different problem to the thread title (I'm new to the forum business!)

I really appreciate your help though, there's no way I'd have worked it out on my own!

The first time a selection is chosen it should display today's date (ie the date on which it is selected) in the date columns to the right which works perfectly now.

For column G it should change to the date that each selection was originally selected. For example if the job was marked as "Quoted" on 2nd September, the date would show up in the columns to the right and column G. At a later date, eg 4th September the status would change to "Confirmed" and the date would be entered in the relevant date cell to the right and column G. If then the handler wanted to see what date the job was marked as "Quoted" he could re-select "Quoted" in the drop down and column G would then display the original date it was selected on that is stored in the date cells to the right. What I'm after is for column G to be like a link to the date cells, and the cell that's referenced changes depending on which status is selected.

Thank you!

Hi

Thanks so much for this - I am in awe of your VBA skills!

I can't test it properly until the morning and the date changes so will let you know tomorrow how it has gone.

Thanks again

Hi Sorus

You're a genius - it works perfectly

Thank you!

I will mark the thread as closed now - I have added some reputation for the first part of the solution but it won't let me add any more for the second bit!