Good morning everyone
I'm new to the forums and try to learn macros and VBA.

I'm currently involved in a project that takes a lot of my time.

Here is the raw data


REX OIL CO INC 8,486.79
REX OIL CO INC 21,998.20
REX OIL CO INC 63.44
RUSH MEDIUM DUTY TRUCK C 97.14
SAFETY-KLEEN SYSTEMS, IN 374.39
SHIPP CORPORATION NO 2 I 4,778.00
SHIRLEY SEPTIC PUMPING I 110.00
SHIRLEY SEPTIC PUMPING I 78.00
SHIRLEY SEPTIC PUMPING I 110.00
SILVERHEELS TOWING & REC 120.00
SOUTH PARK TRUE VALUE IN 37.46
SOUTH PARK TRUE VALUE IN 3.98
SOUTH PARK TRUE VALUE IN 38.59
SOUTH PARK TRUE VALUE IN 5.58
SOUTH PARK TRUE VALUE IN 63.97
SOUTH PARK TRUE VALUE IN 58.98
SOUTH PARK TRUE VALUE IN 13.99

Question: Is there a macro that would total the amounts for each vendor and then delete the duplicate vendor rows?
This is the outcome after I do it manually

REX OIL CO INC 30,548.43
RUSH MEDIUM DUTY TRUCK C 97.14
SAFETY-KLEEN SYSTEMS, IN 374.39
SHIPP CORPORATION NO 2 I 4,778.00
SHIRLEY SEPTIC PUMPING I 298.00
SILVERHEELS TOWING & REC 120.00
SOUTH PARK TRUE VALUE IN 222.55

Thank you in advance!