Function for adding lines

[dpal]

I have 2 tabs. One spread sheet is a summury of the other.
Each line item on one tab goes across. The other tab goes down.( every line
on Tab 1 is equal to 10 lines on tab 2 )
Tab one : XX XXX XXXXX
tab two:line one XX

line five XXX


line ten XXX

Repeat:
Right now I pick a cell on tab one A1 and = the cell A1 on tab 2
A2 and = the cell A5 on tab
2
A3 and = the cell A10 on
tab 2 : repeat
This takes a while.
Is there a formula I can put on tab one EX: for A1 = cell A1 + 5 on tab 2.

Thanks

 

[bj]

try
=indirect("Sheet2!A"&(row()-1)*5) in A2 and copy down

 

[dpal]

Do I right Row() or Row(B)?
I have 48 lines that keep repeating. Each cell on sheet 1 is equal to a
specific cell on Sheet 2. It always repeats the same amout of lines down
So Sheet1 cell $AD$1 is egual to sheet2 $O$53
Sheet1 cell $AD$2 is equal to sheet2 $O$101 etc.
This goes on for 40,000 lines on sheet 2

 

[dpal]

=INDIRECT("Takeoff!B34279,"&( ROW(Description)-1)*5)
Whats wrong with this? it comes up #Name?

 

[dpal]

=OFFSET(Takeoff!$A$34279,5*Takeoff!(ROW(Description)-1,0)
Do you see any thing wrong with this?

 

[bj]

the value in an indirect function has to look like a cell address
what cells are you trying to copy to where and where is the Description cell?
Is Description a named cell?
maybe
=INDIRECT("Takeoff!B"&row(description)+(ROW()-1)*5)

 

[dpal]

TakeoffB is the sheet and colomn how does it know were to start if there
isn't a number after it. Yes Desription is in the first cell of row B.
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.

 

[MyVeryOwnSelf]

... 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