How do I date stamp different fields each time I select an option from a drop down list?

**martyparke** · 04-24-2014, 05:01 AM

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.

**Tinbendr** · 04-25-2014, 03:37 PM

Put this on the sheet1 code page.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim C As Range

    If Not Intersect(Target, Sheet1.Range("B2:B20")) Is Nothing Then
        With Sheet2.Rows(1)
            Set C = .Find(Target, LookIn:=xlValues)
            If Not C Is Nothing Then
                C.Offset(Target.Offset(, -1), 0) = Date
            End If
        End With
    End If
End Sub

**martyparke** · 04-28-2014, 05:47 AM

Thanks a million Tinbendr - works like a dream.

Can't believe I didn't post on here sooner - been pulling my hair out for a long time over this!

How do I date stamp different fields each time I select an option from a drop down list?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How do I date stamp different fields each time I select an option from a drop down list?

Re: How do I date stamp different fields each time I select an option from a drop down lis

Re: How do I date stamp different fields each time I select an option from a drop down lis

Thread Information

Users Browsing this Thread

Similar Threads

Auto date stamp with drop down list?

Select option in HTML drop down list

Date/Time Stamp/User name for drop down changes

Filtering - user select single option from drop-down list?

How to parse date/time stamp into different fields?

Bookmarks

Bookmarks

Posting Permissions