Cell A1 being the date value, and the rest of cells subject to changes. Either Worksheet function or VBA could achieve this? Remark : Usual opening or viewing of WB would bear no effect on it.