Inserting Date Automatically

[gerryger]

I want to create a spreadsheet with three columns. The first column will contain the date. The second two columns will contain various data. I am looking for a formula that will automatically put the date in the first column once there is data in the second or third columns. If there is no data in the second two columns I would like to have the date column left empty. Keep in mind that I would like to date to stay permanent meaning I don't want the date changed to a different date (for example if I edit the spreadsheet a week later).

[mudraker]

You can not do what you want with a formula. you need a worksheet change event macro


'These instructions pre typed & are worded to cater for the novice programmer
'To install macro to correct location

'Copy this macro
'GoTo Excel
'Select sheet this is to appy to
'Right Click on Sheet Name Tab > select View Code
'Past macro into the Worksheet Module displayed

Please Login or Register  to view this content.

[tnxrb7]

mudraker,
Thanks. This is great. Is there a way to change the reference from column A to, let's say, row 1?