| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 -- |
|
#6
|
|||
|
|||
|
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 -- |
|
#7
|
|||
|
|||
|
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! |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying data to an adjacent cell | Excel Discussion (Misc queries) | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| Selecting data within a date range | Excel Worksheet Functions | |||
| Retrieving non adjacent data from other workbooks? | Excel Worksheet Functions | |||
| Need to use IF formula with a Date cell | Excel Worksheet Functions | |||
Linear Mode
