if/then insert date but don't want automatic updates
Start by recording a macro. Don't care what it is. When that is done, Select
Tools - Macro - Macros - Edit
Add the following code
Public Function StaticDate(ByVal Cell As Range) As Variant
If Cell.Count 1 Then
StaticDate = -1
Else
StaticDate = Now()
End If
End Function
Now go back to your spread sheet. Add the formula
=StaticDate(A1)
to the cell where you ant the date to appear (change A1 to the cell that
triggers the date to appear).
Now whenever cell A1 is changed the date will be changed in the cell where
you added this formula. This is a regular formula that can be copied and
pasted and...
--
HTH...
Jim Thomlinson
"redleg" wrote:
I am willing to try if you have an example I can tinker with. Thanks.
"Jim Thomlinson" wrote:
Long story made short... what you are asking for requires macros. If you want
to persue that it is a fairly simlpe macro but it many people don't wnat to
go there...
--
HTH...
Jim Thomlinson
"redleg" wrote:
I have a spreadsheet tracking personnel actions. I tried the following
formula =IF(L2="","",TODAY()) but I do not want the date stamp to
automatically update when the spreadsheet opens. How can I write a simple
formula so that when the cell has text entered into it, the date will be
recorded in the adjacent cell as a static stamp? Thanks.
|