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

Select sheets ina workbook based on radio buttons and move them 4
my cursur does not work in my word document? 1
collect data from one excel sheet to another 3
How do I fill every other line with a color? 7
Select (highlight) Text in txtBox at Initialization 4
Amazon Login Location Different 4
coloring overy other line without doing so line by line 5
Word How to delete line in Word 3

Top