How to copy data and then increment cell reference from different worksheet Excel 2003

Hi,

Could anyone help me please ? I've tried lots of ways to do this, but none successful so far.

I've got 2 worksheets in the same workbook.

Sheet 1 contains huge amounts of data - thousands of rows and multiple columns

Sheet 2 - I want to extract the data from sheet 1 column A into sheet 2 column A but only the data from every 21st row.

I want to be able to copy the formula automatically down, otherwise it will take hours to do it manually. So far I can only get the cell reference to increment by 1 each time after copying.

So what I'm trying to achieve is :-

Sheet 2 A1 = Sheet 1 A1
Sheet 2 A2 = Sheet 1 A22
Sheet 2 A3 = Sheet 1 A43

If anyone can help me out with this, I'd be most grateful.

Thanks,

M.

Perfect !

Works like a treat.

Thanks very much XOR LX.