VLOOKUP in VBA to find search with multiple occurences

[iswizzle]

So I'm attempting to write a macro to loop through an array of data and return all instances of the criteria. Using the following code, I am getting 1999 entries of the same date.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Is there any way find all occurrences of Employee_Name in the Lookup_Range?

Any advice would be greatly appreciated!

[stnkynts]

What do you want to do with said "found occurences"?

[rcm]

Please Login or Register  to view this content.

[iswizzle]

I want to list how many times an employee got hurt. So loop through all the data, which is first aid data on current employees, find any time "Fred" was hurt, then list the date in column H of Template (2)

[iswizzle]

Please Login or Register  to view this content.

The whole for loop inserted?

[stnkynts]

What is the relationship between the persons name and the date in range C1 to L2000 is the date above, below, to the right, etc? Is the name in only one column? Can the dates in column H of the Template (2) be stacked together or do they need to be representative of the initial row source?

[iswizzle]

What is the relationship between the persons name and the date in range C1 to L2000 is the date above, below, to the right, etc? Is the name in only one column? Can the dates in column H of the Template (2) be stacked together or do they need to be representative of the initial row source?

Name is in column C and date is in column D. And I'm not quite sure what you mean.. Excel noob here :P

[stnkynts]

Please Login or Register  to view this content.

[iswizzle]

Please Login or Register  to view this content.

worked perfectly. thankyou!!

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.