Sort one excel sheet into two based on territory criteria

Hello everyone! I am new at using VBA and macros, but think that they are the answer to my problems. I have tried a number of formulas but cannot seem to find one that will work for me. And now in going through the tutorials on macros online, am still confused! Here is my problem.

Within my one excel spreadsheet I need to split it into two spreadsheets based on which state the row is associated with. Additionally within a few states there are exceptions based on the "company" columns criteria which would need to be further sorted. I currently am using another excel spreadsheet which serves as a reference for when I am splitting the one worksheet into two. I have attached both sheets below- the two different color highlights show the breakdown of how I need to split the sheet into two green and yellow. The darker yellow highlight are the exceptions to the state sorting.

Hello VBA?,

Welcome to the Forum!

Your title should provide more detail about your question. Since you have two workbooks and you have some code and/or formulas written, you should post all this information. Please see the forum rules for information.