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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically Add numbered rows in sequence from a given number
A20 is not a column.
Formulas cannot add rows. You will need VBA code to add your rows. Where do you want the rows added and which two cells contain the numbers 40 and 30 Gord Dibben MS Excel MVP On Tue, 2 Sep 2008 14:01:01 -0700, Six Sigma Blackbelt wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically Add numbered rows in sequence from a given numbe
Thanks Gord, your reply has given me a new direction, what I really need is
excel to do, is to insert numerical numbering into the cells starting at A19, the formula in B15 multiples B9, B10 and B13, so whatever is the sum of B15, I need Excel to start inserting numbers numerically at cell A19 to whatever the sum of B15 is, so if B15 is 30, I need 1 thur 30 inserted starting at A19 thru A49. Your reply help me re-state my problem. So I need to insert numbers, instead of rows. Thank you Again "Gord Dibben" wrote: A20 is not a column. Formulas cannot add rows. You will need VBA code to add your rows. Where do you want the rows added and which two cells contain the numbers 40 and 30 Gord Dibben MS Excel MVP On Tue, 2 Sep 2008 14:01:01 -0700, Six Sigma Blackbelt wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically Add numbered rows in sequence from a given numbe
Six Sigma Blackbelt wrote:
Thanks Gord, your reply has given me a new direction, what I really need is excel to do, is to insert numerical numbering into the cells starting at A19, the formula in B15 multiples B9, B10 and B13, so whatever is the sum of B15, I need Excel to start inserting numbers numerically at cell A19 to whatever the sum of B15 is, so if B15 is 30, I need 1 thur 30 inserted starting at A19 thru A49. Your reply help me re-state my problem. So I need to insert numbers, instead of rows. Thank you Again In A19 and then copied down as far as necessary: =IF(ROW()-18<=$B$15,ROW()-18,"") |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically Add numbered rows in sequence from a given numbe
Good work Glenn
Gord On Wed, 03 Sep 2008 10:22:08 -0500, Glenn wrote: Six Sigma Blackbelt wrote: Thanks Gord, your reply has given me a new direction, what I really need is excel to do, is to insert numerical numbering into the cells starting at A19, the formula in B15 multiples B9, B10 and B13, so whatever is the sum of B15, I need Excel to start inserting numbers numerically at cell A19 to whatever the sum of B15 is, so if B15 is 30, I need 1 thur 30 inserted starting at A19 thru A49. Your reply help me re-state my problem. So I need to insert numbers, instead of rows. Thank you Again In A19 and then copied down as far as necessary: =IF(ROW()-18<=$B$15,ROW()-18,"") |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically Add numbered rows in sequence from a given numbe
Gord Dibben wrote:
Good work Glenn Gord Thanks! |
Reply |
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) |