... I am trying to get sheet1 B1 to equal sheet2 B1 , then sheet1
B2 to equal sheet2 B10. Doing this with the formula This goes on for
10000 lines on sheet 2 so I need 100 lines on sheet one.

Sorry, but (at least to me) the problem statement seems to keep changing.
If you look up OFFSET(), ROW(), and COLUMN() in Excel's built-in Help,
maybe that'll spark a solution.


From the description above, you want to copy each 9 rows of Sheet2 to
Sheet1, for a total of 1112 lines (not 100), assuming equally-spaced rows.
This works when I try it:

Put this in Sheet1!B1:
=OFFSET(Sheet2!$B$1,9*(ROW()-1),0)

Copy down to B1112