I have a worksheet that has a data input page linked to a number of pages in
which the inputted data appears. eg on data page one,cell A6 is linked by a
formula to a cell on the data input page - (=data!A15) . If I try to edit the
formula, to say
(=data!A18) then the formula appears in the cell rather than the data it is
linked to.
I think I am missing something simple, but could someone help me resolve
this please?