Good Afternoon,

I've been struggling with this for sometime and I have searched everywhere for a solution.

I have a list of company names see below;

Capture.JPG

Somehow I need a formula or macro to add a blank row to separate the different companies as below;

Capture2.JPG

And if possible a formula to total up the amounts;

Capture3.JPG

The only outcome I am bothered about is knowing the total amount for each company. For the past year I have been using the filter option which is very time consuming considering there are about 300 companies in total. So any help would be greatly appreciated.

Many thanks,
Dan