Copying data to keep a progression going

  • Thread starter Thread starter jr
  • Start date Start date
J

jr

1) input your formulas into cells A1, A2 thru A5 (that
should be enough).
2)copy range A1:A5 to A6
3)copy range A1:A10 to A11
4)copy range A1:A20 to A21

There might be a more elegant way but this should work.
Each copy will double the number of formulas copied.
 
Sorry jr this doesn't work. What I need it to is to copy
the existing pattern of formulas in the cells and
continue it.
 
sorry for the wild goose chase. This is not elegant BUT
it works.
1)create an out-of-the-way column (let's say, column J)
with the entries:
J K L
1 1
2 4
3 =J2+4

2) copy J3 down as many cells as the number of cells as
needed

3) use this formula in the first cell that you want data
copied to and copy the formula as needed

=INDEX(Sheet2!$A$1:$A$21,B1)

of course, your Sheet might have a different name and you
specify the range that data is read from on that sheet.
Be sure to use the "$" for the range to keep the range
absolute

I've tested this.
 
Back
Top