Date stamp when a value is entered in a cell

  • Thread starter Thread starter bbrant2
  • Start date Start date
B

bbrant2

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!
 
Look here:

http://www.mcgimpsey.com/excel/timestamp.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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!
 
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.
 
Back
Top