View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default Date and time stamping multiple cells for multiple entries.

See

http://www.mcgimpsey.com/excel/timestamp.html


In article ,
Gerald wrote:

I am using EXCEL to track various activities. How can I get multiple date
and time stamps to automatically fill? For example; Cell A2 is filled in
with data and cell G2 date and time stamps when cell A2 is completed. Then
when the next activity is entered in cell B2 the date and time is stamped in
H2.