I have two sheets.
In the first sheet, cell F4, I have 00:00:00 (countdown). G9, G10 and G11 are cells that receive live data (decimal numbers).
In the second sheet, I have three cells linked from sheet1, G9 ='Sheet1'!G9, G10 ='Sheet1'!G10, G11 ='Sheet1'!G11 (which update themselves when data is modified in the first sheet).
Now I want to set in sheet 2, (assume) cells B9, B10 and B11 to show me (copy) the values from G9, G10 and G11 from sheet 1 when the countdown was 00:00:05 (5 seconds before Start) and not update again if the data changes in the cell it pulled the data from.
Like G9 ='Sheet1'!G9 at 00:00:05 and stop here, do not update anything. OK?
I can do a part, but the real problem is: I can not make it stop cells to update. Stand frozen, freeze, not move, calm .. however.
I do not want to seem pretentious (but my knowledge in excel is limited), the most appropriate would be a formula, not macro or VBA, if possible.
I want to post a picture but I can not because of my restrictions.
Well, if this is not possible with a formula is just fine with (not really) VBA.