Using 07.
I am looking to display the current date in a designated cell when ever a modification to any cell withen a range or colum is made and the document is saved.
I have tried a few things unsuccessfully and would appriciate any help.
Using 07.
I am looking to display the current date in a designated cell when ever a modification to any cell withen a range or colum is made and the document is saved.
I have tried a few things unsuccessfully and would appriciate any help.
Hi -
Please post some codes that you have started with and we can go from there. Likewise, a sample file would be helpful.
Regards,
event
Last edited by event21; 10-22-2012 at 11:04 PM.
I have used this code below to do basically what you are saying but I am also trying to get the date to show up no matter which cell in a range has data inputted to it.
=IF(B3<>"",IF(A3="",TODAY(),A3),"")
if anything is put it cell B3 then the date is put into cell A3, but I have a bunch of cells that can have data inputted and would like the date to show in cell A3 no matter which one gets filled first.
Here are the other cell addresses I am using: F3,J3,N3,R3,V3,Z3,AD3,AH3,AL3.
I don't know how to add these other cells into the formula above to make this work. Any ideas would be greatly appreciated!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks