Hello Everyone,

I am brand new to this forum, and not very skilled with VBA; however, I believe it would help me greatly with what I am trying to do, so if anyone would be kind to help out, please do.
I have a large spreadsheet with names of certain facilities. I receive those spreadsheets from different people, who tend to name same facility a different name. I need to combine all the numbers for the same facility into one. As an example, I need to combine all numbers for a facility named ABC, but my worksheet looks like this:
A B C D E F
Facility name Jan Feb Mar Apr YTD
ABC 2 1 4 1 8
ABC 3 0 2 0 5
ABC EF 1 1 1 1 4

So those are all the same facility, but I need them all combines into just one row instead of 3, so I can have a grand total this way.
Also it would be great if the spreadsheet could search for similar names and combine into one if maybe accepted by the user?

Please let me know what would be the best way to solve this problem, as it would save me lots of time and frustration.