Results 1 to 3 of 3

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

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2014
    Location
    Derry
    MS-Off Ver
    Excel 2003
    Posts
    2

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

    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.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto date stamp with drop down list?
    By gavster in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-19-2017, 11:11 PM
  2. Select option in HTML drop down list
    By JohnsonJiang in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-15-2014, 03:28 PM
  3. Date/Time Stamp/User name for drop down changes
    By Austenparker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2014, 11:51 AM
  4. Replies: 4
    Last Post: 02-07-2014, 12:49 AM
  5. How to parse date/time stamp into different fields?
    By chrishornbeck in forum Excel General
    Replies: 1
    Last Post: 05-07-2008, 12:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1