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 ?
Bookmarks