Show (copy) data at "X" time and stop update.

**Anka** · 09-01-2012, 10:16 PM

Hello everyone.

Here I am, once again, with another problem! I try to give a good explanation.
I have two sheets. In the first sheet, I have cell F4 is 00:00:00 (countdown). G9, G10 and G11 are cells that receive data (decimal numbers) live.
In the second sheet, I have three cells linked from shhet1 G9 ='Sheet1'!G9, G10 ='Sheet1'!G10, G11 ='Sheet1'!G11 (which update themselve 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 are limited), the most appropriate would be a formula, not macro or VBA, if possible..

Thank you in advance.

**Anka** · 09-02-2012, 07:11 PM

Because my English is not good at all, I prepared an example here.

**Anka** · 09-03-2012, 12:45 PM

Is not any solution?

**Anka** · 09-05-2012, 03:59 PM

I found an answer to the problem in another forum. If another newbie like me needs solution, I post the link here if I may. Can I ?

**icestationzbra** · 09-05-2012, 04:44 PM

hi anka,

i am sorry to see that we weren't able to help you with your problem for about 4 days now, even though you (rightly) kept bumping up the thread.

it is very nice of you to offer to share the solution with the rest of us; we would certainly be thankful and welcoming of that. please do share the solution (or a link to it).

i hope that your experience here will be better in the future.