| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically Add numbered rows in sequence from a given number
I need to automically add rows to my worksheet. The number of rows will be
derived from a number that is sum by two other numbers inputed into the sheet. The sum number will dictate how many rows to generate numerically. Example, so if the two numbers to be sum are 40 + 30 the sum is 70, I need excel to generate 70 numerical (1-70) rows in a specified column like A20, how can I produce this in a formula? Stuck, spinning wheels MJS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel2003 - Automatically sum a variable number of rows | Excel Worksheet Functions | |||
| Automatically have even numbered rows shaded gray? | Charts and Charting in Excel | |||
| how to automatically number rows in an excel worksheet | Excel Worksheet Functions | |||
| HOW DO I RE-NUMBERED MY NUMBER COLUMN AFTER I ADDED ROWS? | Excel Discussion (Misc queries) | |||
| how do I put a a sequence number into colun A automatically witho. | Excel Discussion (Misc queries) | |||
Threaded Mode
