I use excel 2007 and have a spreadsheet which has 350,000 rows of
data.

The data consists of many ranges.

Each range has a cell containing a formula. These cells are in the
same column but refer to different cells on another sheet.

I want to put the formula on the row above each range.

If I copy/paste I just get the result of the formula. Is it possible
to to have a formula which copy/pastes another formula???
Big thanks.
Colwyn.