Hi,

I have a massive spreadsheet that has a number of coloums
the two main coloums are (Column B = Amount £) & (Column F
= Company). e.g.
Column B Column F
£100 Blogg Ltd
£200 Smith PLC
£300 Smith PLC
£400 Jones Ltd

I would like a macro that when clicked will look down
coloumn F and total the amount for each company e.g.

Blogg Ltd = 1
Smith PLC = 2
Jones Ltd = 1

I would also like the macro to then add the amounts for
each of the companies e.g.

Blogg Ltd = £100
Smith PLC = £500
Jones Ltd = £400

Is this possible,

Thanks