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