Thanks Max,
that one was a little harder to figure out, but now that I've gotten the
hang of it, it works GREAT! Thank you so much Max and Sheeloo
Ben

"Max" wrote:

If you need it to propagate across as well,
to reference/grab the other cols in the source range (besides col A)
you could use this in any start cell in Sheet1, say in B2:
=OFFSET(Sheet2!$A$2,ROWS($1:1)*2-2,COLUMNS($A:A)-1)
Copy B2 across/fill down as required

Here's some easy adaptation notes:
Sheet2!$A$2 is the anchor cell
Point it to the top left cell in the source range

ROWS($1:1)*2-2 is the row param
It increments to produce the required "skip" step of 2
Eg if you need it in steps of 5, use: ROWS($1:1)*5-5

COLUMNS($A:A)-1 is the column param
It increments to produce the simple series: 0,1,2,3..
as the formula is copied across, providing the propagating bit to
reference/grab the other cols in the source range
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---
"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?