Need a Macro to Filter out certain groups of data

[XIGRIMxREAPERIX]

I need a macro to sort through the data I have and display only certain groups.
For example I need all the data that comes from a group with an A suffix
Desktop.PNG

[briguin]

I'd build a macro that:
- Found the bottom row of the data
- Started a search from the top row to the bottom row
- Each time I hit a value in column A, I would see if the Right(colA.value,1) ="A" I would write it to another sheet.
- If the next value was blank and had a value in colB then I would write to the sheet.

In the end you would have a sheet full of _A values.