Hello.
I hope that someone will be able to help me with this issue....

I have the following in a spreadsheet. The spreadsheet is created
dynamically - an array of data is passed to it from my ASP Page.

The columns are fixed, however the rows will change.
How can I work out the %Turnover? - I've worked it out manually below.

The calculation will be: Turnover/Total Turnover(for (each) Group)*100


Branch Account No Turnover %Turnover
Cambridge 1 50.00 44.23%
Cambridge 2 48.00 42.48%
Cambridge 3 15.00 13.27%

Cambridge Total 113.00 <- Total Turnover(for the Group)

There can be many groups - depends on the users selection criteria.

The column data are as follows:
Branch - Column B
Turnover - Column E
%Turnover - Column I


Someone suggested pivot tables. Is this a bit far-fetched??
I was thinking of using the $ character plus some VBA code
I have all the information in the spreadsheet - just need the %Turnover.

Any help will be much appreciated.

TIA