What was the formula in the original cell?

What is the formula in the pasted cell?

Do you have calculation set to manual?

Depending on what the formula was in sheet1, the pasted cell will refer to the
cells in sheet2.

Maybe you want to cut the cell and paste???

ajs wrote:

Il explain better.

I have a table containing values in sheet 1. On sheet 2 i have a table
reading the logs of the values from sheet 1. I have inserted new
columns onto the table on sheet 2 and want to drag the Log formulae on
to it. However, when i click and drag it reads the correct formulae in
the formulae box above but it gives the value from the selected cell.
Also, when i change a value in sheet 1, the corresponding cell on sheet
2 does not update with the new log value.

I have someone typing the formulae into these blank cells by hand now.
But this will become tedious if i have to do this every time. Ure
ideas are much appreciated.

--
ajs
------------------------------------------------------------------------
ajs's Profile: http://www.excelforum.com/member.php...o&userid=36046
View this thread: http://www.excelforum.com/showthread...hreadid=558379

--

Dave Peterson