View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CHENG28 CHENG28 is offline
external usenet poster
 
Posts: 1
Default MACRO or FORMULA

I am trying to make a spread sheet which has a cell with a drop down function
from which a name can be selected - that is no problem.
What I would like to do is when a name is selected from the drop down, I
would like to have the cell below it self-populate with the time and date.
I have talked to many users much more experienced than I, and have not been
able to figure out a method to do this.