Is there a way to split up Even and Odd Number rows

[Jack-P-Winner]

I have 3000 rows of data and I would like to split up all the Even Number rows and odd number rows. Is there a formula or Macro to do this?

It starts out like this



And I am trying to do this

 

[NARAYANK991]

Hi Larry ,

In column AG you already have a sequence of zeros and ones , presumably through a formula. If this extends over all 3000 rows of data , then you can use the Autofilter facility to filter on 0s and 1s one after the other , and copy the resulting rows to separate worksheets.

Narayan

 

[Aby]

if you do not like to filter on the odd/even rows by using the excel formulas for odd/even and paste the resultant values to a separate sheet then we need to do this using macros.
can u give me the worksheet, if its macros that you need?

 

[Jack-P-Winner]

if you do not like to filter on the odd/even rows by using the excel formulas for odd/even and paste the resultant values to a separate sheet then we need to do this using macros.
can u give me the worksheet, if its macros that you need?

The worksheet is way to large to upload but here is an example

 

[Jack-P-Winner]

Hi Larry ,

In column AG you already have a sequence of zeros and ones , presumably through a formula. If this extends over all 3000 rows of data , then you can use the Autofilter facility to filter on 0s and 1s one after the other , and copy the resulting rows to separate worksheets.

Narayan

I was thinking this would be time consuming to do but will go through the exercise and see, Thanks Narayan

 

[Mike H..]

Cross posted here

http://answers.microsoft.com/en-us/...c0429b3-ac42-4d6f-9927-e6be84ad794d#LastReply

 

[bobhc]

Jack it is good practice and manners to inform members of all sites you have posted a question on that you are using more than one site, nothing wrong with using multiple sites but members of a site may spend a lot of time trying to help you when unknown to them someone else has done the same work but on a different site.
From the post you have on the above site you are asking all your questions on multi site forums, a lot of members work is being unnecessary duplicated, don't for get members give their time for free.


.

 

[Jack-P-Winner]

Jack it is good practice and manners to inform members of all sites you have posted a question on that you are using more than one site, nothing wrong with using multiple sites but members of a site may spend a lot of time trying to help you when unknown to them someone else has done the same work but on a different site.
From the post you have on the above site you are asking all your questions on multi site forums, a lot of members work is being unnecessary duplicated, don't for get members give their time for free.


.

I did indeed but was not intentional, I had asked another question and a Rick answered it quickly with a Macro and I decided to ask how I could change his Macro to accommodate this sheet and forgot to place the cross post. Still not answered and when I do get one I will place the answer on the other forum to share with others