View Single Post
  #4   Report Post  
Christina
 
Posts: n/a
Default

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