Selecting every odd row

I

instauratio

I have a spread sheet with 2000 rows. I want to select every odd row and move
it to aother sheet. Keeping the even rows on the first sheet. I want to
select them without having to go through and select each one separately (1000
selections).

I know this sounds bizarre, but if i can do this it will save me hours of
work.
 
B

Barb R.

That's easy! Try this equation and use AUTOFILTER to select the rows you
need to copy and copy them to the sheets as needed..

=MOD(ROW(),2)

Barb Reinhardt
 
D

Dave O

Here's one way to do it:
Step 1: make a backup copy of your data so you don't lose anything.
Step 2: At the left-most column, insert 2 new columns.
Step 3: In the new column A, starting at row 1, number each row using
your favorite method (data fill, etc).
Step 4: In the new column B, in row 1, enter 0. In the following row,
enter 1. In the row after that, enter this formula: =B1 (or whatever
row holds the zero value in this column). Copy this formula down to
the last column. You should see 0,1,0,1 etc alternating through the
entire list.
Step 5: Sort all rows on column B. All the zero entries will be
grouped; all the 1 entries will be grouped.
Step 6: Move the appropriate group to a new tab.

Column A will allow you to re-sort data into its original order if for
some reason it gets out of order.
 
Top