View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robzrob robzrob is offline
external usenet poster
 
Posts: 159
Default put date and time in cells after entry made in shared workbook

I've got a shared workbook which will be used by 5 or 6 users. A user
entry will consist of the user making 6 cell entries or possibly more
in the future (one in each of columns C to H). I want the date of
entry to appear in the corresponding row of the entry in column A and
the time, similarly, in column B when the user saves their entry.