This may be a simple approach, but here goes...

Lets say in cell A2 is your drop list. Format cell B2 for Time, and cell C2
for Date and insert the following formulas.

in cell B2 insert: =IF(A2="","",NOW())
in cell C2 insert: =IF(A2="","",TODAY())



"Kelly" wrote:

I have a list of names and I want to put those names in a drop down list.
Once someone selects a name from the drop down list I want that name and the
current date and time to populate that cell. Does anyone have any
suggestions?