if data in one cell, then date in adjacent cell
 

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(b10,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

if data in one cell, then date in adjacent cell
 

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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jane" wrote in message
...
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(b10,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

if data in one cell, then date in adjacent cell
 

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" wrote:

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

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jane" wrote in message
...
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(b10,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

if data in one cell, then date in adjacent cell
 

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 !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jane" wrote in message
...
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

if data in one cell, then date in adjacent cell
 

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)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

if data in one cell, then date in adjacent cell
 

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

"Max" wrote:

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)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

if data in one cell, then date in adjacent cell
 

Glad the message got through !
All the best ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jane" wrote in message
...
Thank you Max, will give it a try. Appreciate your help!

if data in one cell, then date in adjacent cell
 

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" wrote:

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 !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jane" wrote in message
...
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

if data in one cell, then date in adjacent cell
 

Welcome. Kind of you to post the feedback.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cher" wrote in message
...
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