Macro Help - Subtotaling Cells w/ Same Name Info

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

Hi

why don't you just add some headings, and use a pivot table? Much easier.

rylo

Hah. Guess I didn't think of that.. Thanks

Thank you everyone for the replies..! I guess I've been trying to learn VBA, so I get stuck in that mindset and forget about the other, more simple features Excel has to offer =P

Thanks again, I truly appreciate your help!