Hello All,
I've attached a spreadsheet I am having problems with in working out % totals for 2 columns.
The calculations for each row within the group should be as follws:

%Turnover = Turnover(£)/Total Turnover for Group * 100.
%Profit = Profit(£)/Total Profit - for group * 100.

The spreadsheet is dynamic therefore the Total Turnover/Total Profit will almost always be in a different row. However, the columns are fixed.

I'm hoping someone will be able to revamp the existing code which quite nicely groups the records by Branch and totals up 3 of the columns..

Kind regards

I hope that attached file would be useful...
During my work I made many samples of code depending on tasks I've been asked so here I am if you want to share our experience :-)

I hope that attached file would be useful...
During my work I made many samples of code depending on tasks I've been asked so here I am if you want to share our experience :-)

I hope that attached file would be useful...
During my work I made many samples of code depending on tasks I've been asked so here I am if you want to share our experience :-)