select ever other line

  • Thread starter Thread starter dlotz
  • Start date Start date
D

dlotz

is there a way to selct every other line for a copy and past pourpoe
not sahde every otehr line by select
 
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.
 
You must log in or register to reply here.

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
Access How Current page of a form Read Only 2
Insert Calander 0
my cursur does not work in my word document? 1
Amazon Login Location Different 4
collect data from one excel sheet to another 3
add page numbers to selected sheets 1
Chkdsk "replacing invalid security id with default id" windows xp 4

Back
Top