I hope this hasn't been asked before - I couldn't find it anyway but apologies if so.
I have a workbook with a drop down box in column b. The drop down has 15 options.
Each time I select an option I would like that date to appear.
So if I choose Stage 2 in square "b2" then it puts todays date on another worksheet in the "Stage 2" column.
Then, tomorrow if I choose "Stage 3" (again in square "b2") it puts tomorrow's date into the other worksheet in the "Stage 3" column.
And so on until there are corresponsing dates for each stage from 1-15 and I will use this to see where any delays appear?
And then this replicates down all the columns for each job that's ongoing.
Maybe this will help make more sense of it?
I hope it has attached correctly?
Many thanks to anyone who helps.
Please let me know if I've broken any rules about how to post etc.
Bookmarks