Number of times different names show up in Excel

[fitakyre]

I'm new to Excel macros, and I've been googling around to try to figure out a solution to my problem and it's been driving me crazy.

I would like to make an Excel file with two sheets:
In one sheet, a list of names would be located in a column, e.g. Column A. The list of names will be populated by something else so I have no control over what names will show up.
In the second sheet, I would like to set up a macro that scans the column of names in sheet one and populates Column A with all unique names and Column B with the number of times that name pops up in sheet two.
Then in future iterations, I would like for the macro to be able to scan a whole new list of names and populate Column A with any new unique names and add the number of instances of all the names to the number of instances already present from before in Column B.

Is this at all possible?! I'm going crazy. Any sort of direction or hint would be massively helpful. Thank you!

[LJMetzger]

Hi fitakyre and welcome to ExcelForum,

See post %2 in the following thread which answers a question that is similar to yours: http://www.excelforum.com/excel-prog...nd-sheets.html

When looking for unique items in Excel, there is a VBA tool called the 'Scripting Dictionary' which is very useful. For more information see:
http://www.snb-vba.eu/VBA_Dictionary_en.html
http://www.experts-exchange.com/Soft...ss-in-VBA.html

I hope this helps.

Lewis

[fitakyre]

This is perfect, thank you so much!