How do I copy a row from one worksheet to another by looking for a character string?

I need to look for a character string in the cells in row A. If the cell contains "GRA" I need to copy the row to the worksheet named "A". If the cell contains "GRB" I need to copy the row to the worksheet named "B" and so on. There can be multiple strings found in one cell. I have all of my worksheets named and I do not have control over how many rows there are in any of the worksheets. I am using Excel 2010.

Because you work in the medical field, I put a little bit more effort haha... The only way I can think of is writing a macro. Take a look the file. Basically, the code is going to look at Column A row #2 to the last row. If the cell contains the key word, then it is going to copy the entire row to the destination worksheet.

Please Login or Register  to view this content.

JieJenn, since the column A strings may have multiple matching strings, I don't think you want to use ElseIf, I believe you want to run each test fully, the same row may copy to multiple sheets.

Please Login or Register  to view this content.

Good call. Thanks.

Per JBeaucaire's suggestion

Please Login or Register  to view this content.

I took out the X and Y variables because I imagine the OP is going to add numerous "checks", no need to have a separate "variable" for each sheet individually when an OFFSET() will drop the data into the next empty row.

Thanks for the feedback.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.