Fill cells sequentially but inreasing by 20 cells at a time

[moppyau]

Hi all,
I have a workbook where in sheet 1 A1 I want it to show results from sheet 2 A1, then in sheet 1 A2 show sheet 2 A21, then sheet 1 A3 to show sheet 2 A41 etc. increasing by 20 cells at a time so that at say sheet 1 A10 it is showing the result from sheet 2 A181. I have tried dragging down with & without the Ctrl button but I don't get the result I want. I have attached an example. Thanks in advance.

[Max, Singapore]

One way
In Sheet1, put in A1: =OFFSET(Sheet2!$A$1,ROWS($1:1)*20-20,)
Copy down as far as required
----------------------
Success? Celebrate it, click the little star at the bottom left of my response

[Ghozi Alkatiri]

array formula (Ctrl+Shift+enter)
=INDEX(Sheet2!$A$1:$A$181,SMALL(IF(LEN(Sheet2!$A$1:$A$181),ROW(Sheet2!$A$1:$A$181)),ROW(1:1)))

drag down

[moppyau]

Nice work Max. Thank-you. Thanks also Ghozi.

[wesleypeter]

I have updated the required formulas in Sheet1, Column D to extrac the data Sheet 2, Column A from cells which are 20 rows apart.

Let me know if this was your desired result.

I used the below formula to get the result.

=INDIRECT("Sheet2!" & ADDRESS((ROW()-1)*20+1,1))

Nice to see so many ways to solve a problem.

[moppyau]

Thanks mate. Works just aswell.