Function for adding lines

[Guest]

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

 

[Guest]

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

 

[MyVeryOwnSelf]

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.

The OFFSET() function might help.

For example, try putting this in Sheet1!A1 and copying down:
=OFFSET(Sheet2!$A$1,5*(ROW()-1),0)

(The cells you mention on Sheet2 aren't evenly spaced, so maybe this
suggestion doesn't help. If there's something else about Sheet2 that hints
at which cells to choose, please describe it.)

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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)

 

[Guest]

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