Macro Help: IF specific wording is found in a cell, THEN copy entire row to new sheet

Hello,

I am currently trying to build a macro that looks within a specific cell for wording. If the wording matches one of the numerous sheet names I have, then it will copy the entire row into that specific sheet. I would need the macro to continue that for the remaining data. Hopefully this following examples helps to make things more clear

Column A Column B Column C
Jane Doe Study A $1000.00
John Doe Study B $1500.00
Jim Doe Study C $2000.00

The macro should read column B and determine what study it says. If it sees Study A, then copy the entire row and paste it into the Study A sheet. If it sees study B, then copy it into the Study B sheet, etc. Obviously, if it saw multiple Study A's, then I would need it to copy the row and paste below the initial pasting, so that I can get a total summary of Study A. Does this make sense? Thank you in advance for any help that can be given!

Try this - run the sub test

Please Login or Register  to view this content.

Thalassa,

Thank you for your quick response. I apologize for not mentioning that I am new to the world of Macros in excel. I've primarily taken advantage of the macro recorder and edited the coding slightly if there was an issue. I am attaching a copy of the document that I am looking to work with. This should give you a better idea on how to help me. Thanks again.

I need the macro to look into column G (worked project) and if the project matches one of the project sheets, copy the entire row and throw it into that tab. ALPPrE0105 would go into the ALPPrE0105 tab, ALPPrE0502 would go into the ALPPrE0502 tab, etc.

For column G

Please Login or Register  to view this content.

Thalassa,

This works great. The only issue I am running into is that when it copies the data over the new spreadsheets, it throws them onto row 2. How can I make it so it throws them starting on row 3? The reason I ask is because row two has specific rates that need to be calculated. I am trying to understand your code so I know where to make the edits.

Strange. Maybe

Please Login or Register  to view this content.

I see that you changed the offset to 2. That makes each paste be separated by a blank row. I will look more into your code and see if there is something I am missing. I appreciate your help! Thanks again!

WasWodge,

Row 2 only has data in certain columns. I went forward with your coding and it looks to solve the issue of the extra rows. Thanks for your help!