I am working with an Excel Spreadsheet with a list of names. Each of these
names belongs to a certain category. What I would like to do is create a
macro that searches the column of names and outputs which category each name
falls under and groups them together. I would guess I would have to program
Excel to know which name goes with each category, but I would like Excel to
group them together for me automatically.

Is this possible to do?