count number of x on another sheet

i was creating a workbook with sheet1- containing a list of employees and thier offenses, the names are random in order and there are about more than 500 entries, i need to count how many times the names appeared. on another sheet, i have the employee names with their corresponding manager, i need to add the number of times their names appeared on sheet1 on this sheet under column1..

i was thinking of using a loop statement as follows

Please Login or Register  to view this content.

Be a little easier to offer a solution if we can see your workbook/worksheets are setup. And if can show where you want the results to be shown.

Hi,

Why not use a Pivot Table with the Count of names. See the attached for how I see this problem solved.

i cannot put here the file from the office. Thus I created a similar file, but with fewer entries. There's about 500 employees, and the violation list can span up to 300 entries. i need to count the number of times the employee names appear in the sheet1(violation) and put the number in sheet2(FTE) column1.

i need to use this macro on several workbooks with similar task - counting how many times their names appear. the number of employees will increase by next week, we're hiring again. Thus the FTE (sheet2) will have more names on it by then.

the macro i created on a separate module can only count the first entry, for some unknown reason, it doesn't loop and start back...

Hi,

Once again a simple Pivot Table can count those names for you. No VBA or Code needed..

Like Marvin has said no need for VBA, but if you need heres a code that should do the job

Please Login or Register  to view this content.