Skip one row when dragging from other sheet

[revinob]

Hello everyone, i need help

I want to autofill drag down data from other sheet but skip every 1 row

I.e
On Sheet1
D5 = Sheet2!B2
D6 = Skip
D7 = Sheet2!B3
D8 = Skip
D9 = Sheet2!B4

On sheet2
B2
B3
B4
B5

Thank you

 

[JamesCanale]

MrExcelPlayground8 (version 1).xlsb
	B	C	D
2	A
3	B
4	C
5	D		A
6	E
7	F		B
8	G
9	H		C
10	I
11	J		D
12
13			E
14
15			F
16
17			G
18
19			H
20
21			I
22
23			J
Sheet17

Cell Formulas
Range	Formula
D5:D23	D5	=IF(ISODD(ROW(D5)),INDEX($B$2:$B$11,(ROW(D5)-ROW(D$4)+1)/2,1),"")