+ Reply to Thread
Results 1 to 1 of 1

Macro to Time Stamp Based on Drop Down in Worksheet

  1. #1
    Registered User
    Join Date
    07-15-2016
    Location
    Wisconsin
    MS-Off Ver
    2010
    Posts
    80

    Macro to Time Stamp Based on Drop Down in Worksheet

    I have a workbook with 2 Worksheets. The "SMT Status" sheet shows what product is currently in production, what is up next, and what is after that.
    The "Changeover Log" sheet, is where I want to start getting time stamps of changes made on the first tab.

    In more detail what I am looking for (SMT Status tab):
    -Drop down in Cell C8, C12, C16, and C20 gets changed to "Down - Changeover" it will
    -Find the next available row, Apply the current date to column A of Changeover Log
    -Copy the number in the cell above the drop down(C7, C11, C15, and C20) and paste in column B of Changeover Log
    -Copy the line number from Column B (1-4) and paste into column C of Changeover Log
    - Add time stamp in Column D
    -Then when Drop Down in cell C8, C12, C16, and C20 changes to "Running - online" then it will add a new timestamp to Column E
    - The only challenge with this is the above cell value will be a different value compared to what was previously entered into Column B

    Attached is the spreadsheet

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Time Stamp Based on Drop Down List
    By jankrulak in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-07-2018, 06:05 AM
  2. Creating a time stamp off a drop down list
    By kcgojnur in forum Excel General
    Replies: 3
    Last Post: 03-27-2017, 04:57 PM
  3. [SOLVED] How do I date stamp different fields each time I select an option from a drop down list?
    By martyparke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-28-2014, 05:47 AM
  4. 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
  5. Button to time stamp a row in excell worksheet
    By burdenpi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2013, 02:05 PM
  6. Excel VBA find newest worksheet based on date/time stamp in worksheet name?
    By takchin.tc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2012, 03:56 PM
  7. Date/Time stamp of last edited in worksheet.
    By excelkeechak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2009, 01:07 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