Use this in A1 of Sheet1
=INDIRECT("sheet2!A"&(((ROW()-1)*20)+1))

It will give you A1, A21,A41 from Sheet2 when copied down..

If you really want A1,A20,A40 then
use
=Sheet1!A2 in A1 of sheet1
and
=INDIRECT("sheet2!A"&((ROW()-1)*20))
in A2 and copy down


"dpal" wrote:

Trying to add from one sheet to another without clicking on each cell.
EX:
Sheet 1 Cell A1 = Sheet 2 Cell A1
Sheet 1 Cell A2 = Sheet 2 Cell A20
Sheet 1 Cell A3 = Sheet 2 Cell A40 etc etc.
How can i do this, to drag down on sheet 1 so I get the above results on
sheet 2.
Is there a formula to add lines not quantity?

Thanks