Moving a row to another sheet based on two cells criteria

I apologize if this is a repeat post. I have searched through the forum and found many move macros based on a single cells criteria. Myself being new to macros I am unable to modify them to do what I would like. My issue is I have 10,000 plus rows of data. In column "B" there are numbers starting at 1. In column "A" there are text and numbers. I would like to search column "B" for any number greater than 1. When it finds a number greater than 1 it looks at the value from the corresponding column "A" cell. It then searches the entire column "A" for that value and moves any row containing that value (no matter the value in column "B") to sheet3, deleting it from sheet1. Maybe a better way to explain it, is if the value in column "A" has a value ofther than "01" then all rows containing that column "A" value will be moved to sheet3. Below is an example of the data in case my wording is not clear. 14gh1234 would stay on sheet1 as it only has a column "B" value of 01. All rows for 15ty4567 would be moved to sheet3 as it has values other than 01 associated with it. Any help would be greatly appreciated.

14gh1234 01
14gh1234 01
14gh1234 01
15ty4567 01
15ty4567 01
15ty4567 02

Thanks for the quick response. That method would allow me to sort and manually cut and paste to a different page. I would like to have it doe automatically if possible due to having 10,000 plus rows, with that number increasing each month. I need it to search column B for a number greater than 1, then take the value of column A for that row and search all of column A for that value. As it finds values matching that value it moves them to sheet two. I need to perform various math functions to the data based on if the column A values have multiple column B values. That is also dependent on other things found in the rows. I would just be easier to perform all of the other functions I need to do if I could separate the data based on the above mentioned criteria.

Please Login or Register  to view this content.

I want to thank you for your help. That idea never crossed my mind for some reason. Some times it just takes a second opinion. I tend to over complicate things on a regular basis. I will use your formula above =AVERAGEIF(A:A,A1,B:B) and convert the results to values. Then I will sort the data using that column and simply cut and paste the data to a new sheet. I will just do it all manually at the moment until I can get the macro worked out to do it for me. I am not sure how to mark this question as solved. If you could direct me on how to do that, it would be appreciated. Again thanks for the quick responses.