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

"instauratio" wrote:

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.