hi

I want to set up a formula which copies a value from another cell. I then want to make sure that value does not change in the cell I have set up the formula even if the value in the original cell changes.
For example, I can copy the value in cell A1 (say this is 24) to Cell B6 by using the simple formula =A1 in cell B6 and it will now show a value of 24 in cell B6. I now want to make sure the value in B6 stays at 24 even if the value in A1 changes.

Kate