View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TommyJ[_2_] TommyJ[_2_] is offline
external usenet poster
 
Posts: 1
Default auto enter date in cell on data entry in row

I have a spreadsheet that I want the Date and a couple other value
(strings if it makes a difference) automatically filled in on when
user starts to enter data into a row.

ie.

user enters "foo" in A1 I want the current date to automatically ente
into A2, and an "N" in A3 and A4. this would be regardless of what'
in A1, only that there was data entered.

Thanks for any help offered in advance

Laziness is the Father of inventio

--
Message posted from http://www.ExcelForum.com