excel.JPG
ok so I have a table of codes (combination of numbers and letters) that either end with "-a" or "-b" and each code has a value (numerical).
So I have column A that is the codes and column B that is the value, but i want to sort them into 2 separate tables one table for the codes ending "-a" and one table for the codes ending "-b" but I'm Lost as to how to do this. ultimately the 2 separate "sorted" tables will be on separate spreadsheets accessible by 2 separate groups of people. The original table will change on a regular basis but the codes will still have the"-a" or "-b" identifier.
any help would be greatly appreciated

ps I have basic understanding of excel but little knowledge of the more complex formulas