Thread: automatically Add numbered rows in sequence from a given number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Six Sigma Blackbelt Six Sigma Blackbelt is offline
external usenet poster
  
Posts: 30
Default 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
Reply With QuoteReply With Quote