Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date stamp when a value is entered in a cell
I have a spreadsheet with several different name tabs. Joe tab has col. h-i
that on a daily basis he will go into and put a 1 in. On sheet3, I have all the names listed and when "joe" updates any of his cells in h-i, I have a formula of =IF(Joe!H4=1,NOW(),""), but it's changing the date everyday. I've read some suggestions below on using change function in VB, but not being very familar at all with coding etc. mine obviously didn't work. Any further suggestions or help would be appreciated! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date stamp when a value is entered in a cell
You're updating with the current date and time. What do you want to update
with? Tyro "bbrant2" wrote in message ... I have a spreadsheet with several different name tabs. Joe tab has col. h-i that on a daily basis he will go into and put a 1 in. On sheet3, I have all the names listed and when "joe" updates any of his cells in h-i, I have a formula of =IF(Joe!H4=1,NOW(),""), but it's changing the date everyday. I've read some suggestions below on using change function in VB, but not being very familar at all with coding etc. mine obviously didn't work. Any further suggestions or help would be appreciated! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date stamp when a value is entered in a cell
Look he
http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "bbrant2" wrote in message ... |I have a spreadsheet with several different name tabs. Joe tab has col. h-i | that on a daily basis he will go into and put a 1 in. On sheet3, I have all | the names listed and when "joe" updates any of his cells in h-i, I have a | formula of =IF(Joe!H4=1,NOW(),""), but it's changing the date everyday. | I've read some suggestions below on using change function in VB, but not | being very familar at all with coding etc. mine obviously didn't work. | Any further suggestions or help would be appreciated! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date stamp when a value is entered in a cell
Take a look at the thread that you posted under at your other posting.
http://tinyurl.com/28r266 All the necessary code and instructions there. Gord Dibben MS Excel MVP On Mon, 21 Jan 2008 12:20:00 -0800, bbrant2 wrote: I have a spreadsheet with several different name tabs. Joe tab has col. h-i that on a daily basis he will go into and put a 1 in. On sheet3, I have all the names listed and when "joe" updates any of his cells in h-i, I have a formula of =IF(Joe!H4=1,NOW(),""), but it's changing the date everyday. I've read some suggestions below on using change function in VB, but not being very familar at all with coding etc. mine obviously didn't work. Any further suggestions or help would be appreciated! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date stamp when a value is entered in a cell
Meant to post this as thread. The other was a seach result for bbrant2
http://tinyurl.com/2ay64s Gord On Mon, 21 Jan 2008 12:56:12 -0800, Gord Dibben <gorddibbATshawDOTca wrote: Take a look at the thread that you posted under at your other posting. http://tinyurl.com/28r266 All the necessary code and instructions there. Gord Dibben MS Excel MVP On Mon, 21 Jan 2008 12:20:00 -0800, bbrant2 wrote: I have a spreadsheet with several different name tabs. Joe tab has col. h-i that on a daily basis he will go into and put a 1 in. On sheet3, I have all the names listed and when "joe" updates any of his cells in h-i, I have a formula of =IF(Joe!H4=1,NOW(),""), but it's changing the date everyday. I've read some suggestions below on using change function in VB, but not being very familar at all with coding etc. mine obviously didn't work. Any further suggestions or help would be appreciated! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date stamp when a value is entered in a cell
You will first need to goto Tools-Options-Calculations Tab, and check the
"iteration" checkbox (this tells Excell to allow circular references). Then input the following formula. =IF(Joe!H4=1,IF(A1="",NOW(),A1),"") Replace A1 with the cell the formula is in so that it refers to itself. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date stamp when a value is entered in a cell on another worksheet | Excel Worksheet Functions | |||
Show time stamp when a value is entered | Excel Discussion (Misc queries) | |||
Adding a date stamp to each cell in column - after the fact | Excel Discussion (Misc queries) | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
How do I set an automatic date stamp into a cell in Excel? | Excel Worksheet Functions |