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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Autonumber field in Excel that behaves the same as Access 0
Indenting every other paragraph in Word at the same time? 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Small Thick "Bar" Below Last Typed Line ? 0
Some slides are blank 0
Removing Line Numbers 4

Top