VBA Code for Project

Using object oriented programming on VBA Excel, please write the code in a way that after copying a formatted table on excel, the desired output will appear after pasting the copied contents of the table. Desired output can be seen on the right of the 3 tables. Note, a table can have both "buy" and "sells", only "buys", and only "sells". Code has to be dynamic and work for all 3 scenarios. There can be as many buy and sell items (number of items are not fixed).