View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

One fairly easy way, assume the date is in A2:A200 and you want to copy A2,
A4, A6 and so on, insert a new column adjacent to the one you want to copy
(if it is empty already no need to insert a new column), in this case in B2
you would put

=MOD(ROW(1:1),2)=1

now copy down using the fillhandle to B200, select both column and apply
datafilterautofilter, form the dropdown in B select TRUE, select the
visible range and press F5, select special and visible cells only, press ctrl
+ c to copy and then paste into the other sheet, finally remove the help
range from both ranges

Or from the other sheet use a formula like


=OFFSET(Sheet1!$A$2,ROW(1:1)*2-2,)


copy down


Regards,

Peo Sjoblom





"Christina" wrote:

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