Need Helping Seperate Rows into sheets

Hi everybody first time here and I'm just starting out. But does anybody know how to cut and paste rows to other sheets when the names on the sheets arn't the same. Like i Have information in column C that are States but only the appreviations. I need to transfer only the ones that say "NY" and "FL" to a sheet name State 1 and then all states that are CA go to State 2 and all the remaining states go to a sheet called Other. This is all new to me and I'm completely confused. Thanks.

Thanks for the response. It works I just forgot to include something since I'm still trying to get used to this. On some of the state fields it has wording either before or after the state abbreviation so I was trying to see if theres a way for it to search the cell for those state combinations for the sheets. And is there a way for it to only check one row and stop because I have it running in a loop with other macros and other things need to be done before the state check. I really appreciate your help.

Originally Posted by alansidman

Give this a try:

Please Login or Register  to view this content.

Never mind I figured out one obstacle. The only thing i cant figure out is how to make the above code only do row 2 because I'm going to run it through a loop until it finds and empty cell in Column A. Any suggestions?

Perfect! I Appreciate all the help!