How to move a row of data based on criteria

[DeMetsFan]

Hello,
I am new to macros and coding and would love some help trying to make this work.

I have a workbook that we use for training new managers. Our market is split into an east and west section.

I would like to move the data from this worksheet named Full Roster, to a new worksheet named East if the criteria in column I is East and to a worksheet named West if the criteria is West.

Any help that can be offered would be amazingly appreciated.

Please let me know if I did not explain well enough.

Thanks

 

[kvsrinivasamurthy]

In West sheet in A2

=FILTER('Full Roaster'!A2:I200,'Full Roaster'!I2:I200="West")

Similarly for East sheet you can use formula by changing as East.