select ever other line

D

dlotz

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

Ron@Buy

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.
 
Top