Automating a worksheet in Excel 2003
 

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?

Automating a worksheet in Excel 2003
 

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?

Automating a worksheet in Excel 2003
 

Thank you Dennis,
Unfortunately when I posted this question I inadvertently sent it twice. I
have sent a response on the other thread to Max which would also apply to
yours. It would be a good idea for me to terminate this thread in favour of
the other. Thanks again.
hankb

"Dennis Tucker" wrote:

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?

.