Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automating a worksheet/workbook | Excel Discussion (Misc queries) | |||
MS Excel 2003 automating new worksheet & transfer balances | New Users to Excel | |||
Automating Worksheet Names | Excel Worksheet Functions | |||
Automating Formulas in Excel 2003? | Excel Discussion (Misc queries) | |||
Automating Excel w VB.Net 2003 | Excel Discussion (Misc queries) |