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