Hello!

I am new to this forum and new to Excel macros. I work for a finance company and have a question about how to code a macro. What I need it to do is subtotal cells that have the same name, e.g. stock lot information. So several cells in a single column with a symbol e.g. AAPL, and the shares purchased each date in the next column respective cell. I have attached an example of what I mean (I hope it works, Im new to this). Lot Example.xlsx

I've been trying to figure it out but I'm not very good with coding. I'm sure its a very easy task for an experienced programmer. What I've been trying to do is have it put the subtotal to the right of the last cell with that symbol. It'd be even better if it could start in new columns, with the symbol name and respective subtotal. Meaning, A and B columns are the symbols/lots, and C and D is a single symbol name/subtotaled amount.

I GREATLY appreciate any help with this problem. Thank you for your time and assistance!

~Donny