Thanks Nick. That is exactly what I needed.

"Nick Hodge" wrote:

> Christina
>
> Use a spare column (I used B but any will do), enter this formula and copy
> down to the full extent of your data. You will get alternating TRUE, FALSE
>
> =MOD(ROW(A2),2)=0
>
> Now invoke an autofilter (Data>Filter>Autofilter) and filter on which one
> you want. Copy that data and pate to another sheet.
>
> --
> HTH
> Nick Hodge
> Microsoft MVP - Excel
> Southampton, England
> nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
>
>
> "Christina" <Christina@discussions.microsoft.com> wrote in message
> news:27BB55B4-1DF4-4384-AB89-CFE39F7C461D@microsoft.com...
> >I would like to select alternate rows within a range on a worksheet to copy
> > to another sheet. Any ideas on how to do this?
> > --
> > Christina
>
>
>