stevembe
02-12-2015, 04:05 AM
Thanks for your time reading this post, hopefully somebody can help.
I have a workbook that has 12 worksheets each containing different data, different column names etc so a VLOOKUP will not work with what I am trying to achieve. The one common field that is repeated in worksheets is employee number although always in a different column. Can anybody advise if there is a way to search across the entire workbook and find where an employee number is contained in more than one worksheet but noting that in some worksheets the employee number is repeated so it has to be a search across individual worksheets i.e. not return where the name is repeated in a single worksheet? It would also be useful if the names of the worksheets could be returned as there are 20 of them so perhaps some VBA.
Thank you in advance.
I have a workbook that has 12 worksheets each containing different data, different column names etc so a VLOOKUP will not work with what I am trying to achieve. The one common field that is repeated in worksheets is employee number although always in a different column. Can anybody advise if there is a way to search across the entire workbook and find where an employee number is contained in more than one worksheet but noting that in some worksheets the employee number is repeated so it has to be a search across individual worksheets i.e. not return where the name is repeated in a single worksheet? It would also be useful if the names of the worksheets could be returned as there are 20 of them so perhaps some VBA.
Thank you in advance.