If you can describe fully how you are manually doing the comparison and deciding which file belongs to which group, then a macro should be able to sort through the folder and do the same comparison for you much faster.
For instance...
GROUP A always has "DogFood" in cell A1
You say the headers are the same in ALL files, so that won't work. But you are managing to tell which file belongs to which group somehow...so if you illustrate all four group characteristics, it can be done.
Also, what do you want done after each file is identified as one group. Specifically, what is the end goal?
Bookmarks