Transfer Rows with specific color from Multiple Sheets onto one sheet

I have about 15 sheets in a workbook. Each sheet contains large volumes of data. Some of the rows are conditionally colored yellow based on the certain criteria of a cell in each row. I need a short macro that will copy all the yellow colored rows in each of the 15 sheets into a single sheet.

Plainly put, I don't know how to use an AutoFilter function to search for criteria based on color rather than text

TIA

CJ

I do have the file but it contains a ton of confidential information. I work for a biotech company and all of the data is DNA seqeuences. The file im uploading doesnt have any of the sequences but it contains the name for each sequence and the rows that I wish to move are still colored yellow.

For your reference, I'm trying to copy any yellow row in any of the sheets named "Tag " - "Tag 15" into the last sheet named "MisTagged"

Thanks!

CJ

See the attached workbook. I'm pretty close. I can get the first highlighted row in the first worksheet the code encounters to copy over.

There is a problem somewhere with the looping.

Perhaps a fresh set of eyes will be able to help.

The code runs fine the way it is. There are no error messages so I'm not sure where the code it going wrong.

Sheet Tag12 is why I am trying to have my code loop through each cell in the row. Basically what I was going for was for the code to start in the first cell of the first row, loop through all cells in that row until the end and if any cell was highlighted then copy that row to MisTagged.

Once one highlighted cell was encountered in a row I wanted to have the code quit searching that row (because it has already been copied) and jump to the next row. I wanted the code to do this until the last row on the sheet and then go to the next sheet and do the same thing.

I can get one row to copy and then the code quits. No error though.

Any thoughts?

Adding the sheet name should be easy enough if the original poster needs it once the rest of the code works.

No need, the sheet name from where it came is irrelevant. All I need is just all the information in the row.

Thanks again!

And yes that is a typo. The whole row should be yellow.

Worked perfectly, thank you!