Pulling data from every other row?

[kval2227]

I need to pull data for several hundred rows from every other line so it
should look like:

A2: =dataD2
A3: =dataD4
A4: =dataD6

I assumed I could highlight those first couple rows and drag down but that
doesn't work. Is there any way to do this?

Thanks

 

[Pete_UK]

Put this in A2:

=INDEX(data!D,ROW(A1)*2)

then copy down as required.

Hope this helps.

Pete