Need Help With Matching Function

**kalubalu** · 07-24-2012, 03:49 PM

Hey All,

I need some help with excel vba/fuctions.

I have to add a list in a different tab daily, and I need to find a MACTH with a certain PERSON in a tab and MATCH his numbers on a daily basis. How do i go about doing that in VBA? The numbers will be refreshed daily and there are over 400 people on the list, and manually doing this will be a pain in the a**. Can someone please help. Thank you in advance.

Example:
Find John Doe on both tabs, and on main tab, put "John Doe 2 tickets Monday"

A2: John Doe
B1: Monday
B2: 2 Tickets

I already have coded up to the point where it will ADD John Doe on the main tab, but, dont know how to match it on a daily basis.

**K m** · 07-24-2012, 04:19 PM

The title does meet forum guidelines

**kalubalu** · 07-26-2012, 11:18 AM

Can anyone help solve this question?

**K m** · 07-26-2012, 11:30 AM

How about an example workbook?

**kalubalu** · 07-26-2012, 02:14 PM

test.xlsx

This is a sample of what needs to be done. Hope you can help, thanks in advance.

**K m** · 07-26-2012, 02:39 PM

I see a problem with your data;
Your data goes in order 1,2,3,4,5,6,7 (Mon, Tues, Wed...)
and your lookup data goes in reverse order (7/26, 7/25, 7/24 ....)

It is not impossible to work around but would make the matching more difficult.

I don't have time to help you but others might be able.