I wish to copy a formula to a number of rows in a column using a value from a
particular cell in each formula. What is happening is that when I paste the
copied formula the reference to the cell with the value I wish to use is
moved down with the other cell references.