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.


"bj" wrote:

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" wrote:

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


"bj" wrote:

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


"dpal" wrote:

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