Modifying sort data macro

Originally Posted by rhudgins

I have the following macro that sorts column G and H ascending so that the rows with "Yes" in column G and H come to the top. Next I would like to copy all rows with a Yes in them into B50 and all rows without a yes in column G or H into B100. Can someone help me finish this macro?

If there are 2 rows with a Yes in them, how do you want 2 rows copied into B50?
If there are 2 rows without a Yes in them, how do you want 2 rows copied into B100?

Are you saying that you want all rows with 1 Yes in them moved down to row 50?
Are you saying that you want all rows with no Yeses in them moved down to row 100?
If so, suppose there are more than 50 rows with 2 Yeses in them, do you want them overwritten?

Try explaining again.