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

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

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