select ever other line
 

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

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