i have an interesting question that i hope i can describe in detail enough...

is there anyway to have a cell update itself from another cell at "X" time automatically and not update again if the data changes in the cell it pulled the data from? kinda like it taking a snapshot at that time.

thanks in advance