macro to subtotal a set of data

**mgmisola** · 08-15-2010, 11:35 PM

I have a spreadsheet that has columns for "Side","Stock","No.of Shares","Price" and "Ave.Price"
It is formatted using a macro.

I need macro code that will group all trades by stock. For any changes in stock, function is sum, add subtotal to no.of shares and extension.Then add another subtotal, For
any changes in price, function is sum,add subtotal to no.of shares and extension.Extension is not
included in the columns but I would like to automate to add another field "Extension" right beside "Price". To compute for the values of Extension-No.ofShares*Price.

Can anyone help please?

**venkat1926** · 08-16-2010, 08:58 AM

The file is returned "mgmisole.xls"

column G are unique share names
see formula in H3.copy this down and to the right.

**mgmisola** · 08-16-2010, 09:27 PM

Hi Venkat,
I appreciate your fast response, however my problem is how will I group all data by stock if the number of rows of stock changes dynamically based on my data. I attached the final output for your reference with macro code on it.

Many Thanks in advance!!!