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 (DataFilterAutofilter) and filter on which one
you want. Copy that data and pate to another sheet.
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"Christina" wrote in message
...
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