Matching the records within worksheets

[lovinguy]

Hi,

I am having 9 worksheets which has data about employee.Also I have a mastersheet which has matching records in various sheets.I want to match MasterSHEET with other worksheet example sheet1,sheet2,sheet3 ane sheet4.Matching criteria will be firstname,lastname or email address.Based on match it should pick worksheet name and source column from the worksheets.

To understand the scenario in a better way I have attached the sheet.The output is marked with yellow color.

Thanks

[chaddug]

I'm working on this, but it might take me some time. Just an FYI

[chaddug]

Alright, I am by no means a VBA expert, but this is what I have come up with, maybe someone else can make it better. This will only work if all of your data sheets (Sheets1-4 on the sample file) are setup the exact same way, that means S.NO in Column A, First Name in Column B... etc. I had to tweak the workbook to make it like that, so the code below is only going to work properly on the workbook I am uploading.

That being said, here is what I have come up with:

Please Login or Register  to view this content.

Sample.xlsm

[lovinguy]

If I have 10 worksheet example sheet1,sheet2... sheet10.And one Mastersheet ? I can standardize the columns names for firstname,lastname and email but placement of columns on a worksheet is different.

Thanks Chaddug for your effort but its not working.I tried to enter some values into the sheet and it is not displaying result for firstname matched records.

[lovinguy]

Can someone can help me ?