VBA to time stamp cells whose values are derived from a data validation dropdown list

Natures_Gift,

Col G of attached has DropLists with three options - Person 1, Person 2 and Person 3

If you select "Person 2" in any row, Col H of that row is 'time stamped' as "HH:MM:SS", If you want it to show Date as well, change the format of the Column.

Code as follows:

Please Login or Register  to view this content.

Obviously you will change the Data Validation List and "specific" trigger choice to whatever you want. Just change the Macro line accordingly

Hope this helps

Ochimus

THANK YOU! It worked, however, another code i had in there no longer works i have never never tried multiple codes. Also if i have multiple options in my drop down do i just repeat this portion of the code:

Please Login or Register  to view this content.

Attached is the spreadsheet i am working on. I am on the walk ins tab i am trying to auto stamp with time when the correlating columns have data in them:

Walk ins sheet:

Time stamp Column A when data is in Column B
Time stamp Column H when data is in Column G (drop down)
Time stamp Column J when data is in Column I (drop down)

Appointments sheets
Time stamp Column F when data is in Column D (drop down)
Time stamp Column H when data is in Column G (drop down)
Time stamp Column J when data is in Column I (drop down)