D dlotz Jun 22, 2009 #1 is there a way to selct every other line for a copy and past pourpoe not sahde every otehr line by select
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 Jun 23, 2009 #2 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.
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.
