I assume the formula in F30 includes a reference to cell A1.

All you would need to do is;
1. First change the relative A1 reference in cell F30 to absolute($A$1).
2. Then copy and paste cell F30 to cells N1....N20.
3. Then edit the formulas in cells N1....N20. Change "$A$1" to "$M$1" and
so on to M20.

Dennis

"hankb" wrote in message
...
I have a lengthy worksheet that requires one numerical input on A1 and
produces one numerical output on F30.
I want to apply this process to a column of input data located on, say M1
.... M20 and to achieve related outputs on N1....N20
Is there a simple process to do this?