Construct a VBA summary to main and name/part wise

Hello All,

Good Morning

Please refer my attachment file contains here 2 sheets,rest of the sheets have deleted but I will add later on and do not impact on this working.

I am trying to construct a automate summary VBA from sheet name- combined on sheet name-Cash -del.

1-AbsoluteSummary
Column A=All the each stock name from Combined sheet.
Columb B= sum of qty of each stock irrespective to name from combined sheet.
Column C= sum of Total Value Plus Brokerage Columns of each stock irrespective to name from combined sheet And last divided by Column B against each stock qty.

2-Summary of above further each name wise e.g.PKG,RG,AYU etc
Column A=Each stock name from Combined sheet with name wise separeately.
Columb B= sum of qty of each stock respective to name from combined sheet.
Column C= sum of Total Value Plus Brokerage Columns of each stock respective to name from combined sheet And last divided by Column B against each stock qty.

Having no idea ,how to prepare it ?

Is it possible from VBA Codes ?

Please Login or Register  to view this content.