if data in one cell, then date in adjacent cell

[Guest]

column A is for date and column B is for data entry. I want column A to
populate with date when dat is entered into the adjacent cell in column B.

Currently, in column A, I have:
=if(b1>0,today(),"").

The date does populate when I enter data in column B BUT every day I proceed
down column B and enter data, the date changes in every cell in column A to
the SAME DATE.
How can I have the date stay at the date on whcih the data was entered?
thanks! jane

 

[Max]

This requires vba ..
Try this previous post by JE McGimpsey:
http://tinyurl.com/97xj9

 

[Guest]

I have never used VBA before but now is as good a time as any to begin,
wouldn't you say??

thanks Max! wish me luck

 

[Max]

Jane, I'm sorry. Think I gave you the wrong lead earlier

Try instead JE's "DateTimeStamp Macro" at his page:
http://www.mcgimpsey.com/excel/timestamp.html
(Scroll down the page)

Good luck !

 

[Max]

In case needed,
here's a sample implementation using JE's code:
http://cjoint.com/?loeJIL0Zht
Date_Time_Stamp_Jane_wks.xls

When you input entries into A2:A10,
the date/time stamp will be logged into col B
(when you press ENTER to confirm the input)

 

[Guest]

Thank you Max, will give it a try. Appreciate your help!

 

[Max]

Glad the message got through !
All the best ..

 

[Cher]

I just wanted to say that this area is GREAT!!!!!!!!! I just came here today
and found the information I needed from 05. THIS ROCKS!!!!!! THANK YOU

 

[Max]

Welcome. Kind of you to post the feedback.