Hi,
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
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