- Joined
- Jul 18, 2005
- Messages
- 740
- Likes received
- 2
- Thanks received
- 2
- Location
- Not Liverpool !!
Thanks for helpkramer said:rather than a macro you could link a1 to a2 then compare values and make a3 = now() or soemthing like that when the two cells aren't a match... obviously using IF and hiding a2 etc...
you get the drift... depends on the macro security setting of the proposed target spreadsheet consumer i guess....
Bear in mind that every time you open the spreadsheet, or press F9 tho, the formula will recalculate and display the current date (rather than the date that the cell was changed)Cooperinliverp00l said:Thanks for help
I went with a quick fix. If statement that when a cell doesn't match a certain value it populates another cell with TODAY(). when it does match the certain value then it displays nothing (blank)
It works and is what i wanted
Bear in mind that every time you open the spreadsheet, or press F9 tho, the formula will recalculate and display the current date (rather than the date that the cell was changed)