View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default select ever other line

My method:
Use a helper column
lets say column A. In A2 enter 1 in A3 and copy down =IF(A4=1,"",1)
Filter for a 1 on column A.
Copy and paste what you see on the screen.
Adapt to suit your scenario.



" wrote:

is there a way to selct every other line for a copy and past pourpoe
not sahde every otehr line by select