I have a formula that I need to copy along a row. Part of the formula refers
to cells that are elsewhere in a column. Is there a way of copying the
formula along the row without having to then manually change the references
for the data in the column.