Thank you so very much you are my new favorite person :D

"Sheeloo" wrote:

Try
=INDIRECT("'Sheet2'!A" & ROW(A1) * 2) and copy down

"bigbn487" wrote:

Ok the problem starts out simple enough but I want to skip every other row.
I am having problems figuring out the formula to use to get it to go every
other row. I have tried it with ='sheet2'!A2 and then on the next row having
='sheet2'!A4 and then trying to drag it down, but Excel doesn't recognize
that pattern even if I continue it further. Is there a way I can make it
pull the information every other row to where I can just click and drag the
formula down like normal?
Thank you for your help,
Ben