Here is my problem,, I have a workbook with 4 sheets, sheet one contains a list of people andsecurity numbers that may or may not be on the other sheets, sheet two contains a list of names and security # for company one, sheet three contains a list of names and security # for company two and sheet four contains a list of names and security # for company three.
here is what i want to do, I want to take the people on sheet one and find out which company a person works for, by security #, if not are they listed on sheet two, are they listed on sheet three, or sheet four.
I don't know how vba works right now, so i am kind of looking for a if then formula, any help would be great.
Abanky
here is what i want to do, I want to take the people on sheet one and find out which company a person works for, by security #, if not are they listed on sheet two, are they listed on sheet three, or sheet four.
I don't know how vba works right now, so i am kind of looking for a if then formula, any help would be great.
Abanky