Prev: How do I copying data from a cell on sheet to a diff cell/sheet
Next: Automating a Worksheet
From: hankb on 21 Mar 2010 14:10
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?
From: Dennis Tucker on 21 Mar 2010 21:30
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" <hankb(a)discussions.microsoft.com> wrote in message
news:F4011FF3-2CAD-4E5C-98D9-37883FB5D414(a)microsoft.com...
> 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?

From: hankb on 22 Mar 2010 17:09
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" <hankb(a)discussions.microsoft.com> wrote in message
> news:F4011FF3-2CAD-4E5C-98D9-37883FB5D414(a)microsoft.com...
> > 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?
>
> .
>
 | 
Pages: 1
Prev: How do I copying data from a cell on sheet to a diff cell/sheet
Next: Automating a Worksheet