Pulling data from every other row?
 

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

Pulling data from every other row?
 

Put this in A2:

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

then copy down as required.

Hope this helps.

Pete

On Jan 18, 10:04*pm, kval2227
wrote:
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