Thanks to all who have helped me on my last question.

I need to know if there is a way of creating a macro to do the following:

Find the number of times a name ocurrs in a column and then on a different sheet in the same workbook, place the number of times into a different column. Preferably without making the first column the same one each time, although this is not a problem.

Therefore if the name Smith appears 5 times in sheet 2 column c then it will place the number 5 in column H cell 2 in sheet 1, and so on down the list of names. Obviously the cells in sheet 1 will change for each person's name.

I suspect that it will involve VLOOKUP, but I'm not well versed enough in Excel to get it right.

I need to do this for multiple names.

Thanks

Gorky