Search cell value in all worksheets & return the name of the worksheet where it was found

Hello Everyone ,

I need help with some VBA programming.

Attached is excel sheet.

What I have

1. worksheet "mastersheet" has names of all the people working in a site
2. individual worksheets are names of project where engineers from mastersheet are working . "project 1" ; "project 2" ; 'company 3" and "project 3" has names from "mastersheet" indicating who is working where

What I want

1. To have a code that looks for each engineers name in Range A5:A15 from Mastersheet in each worksheet
2. retrn the worksheet name onto corresponding cell (range B5 thru B15 in Mastersheet)

Example...

• code looks for Adam and returns project 1
• code looks for hazenstab and returns "not in any project"
• code looks for ireson and return project 2

What I am trying (skeleton wise)

https://stackoverflow.com/questions/...orksheet-excel

Try this:

Please Login or Register  to view this content.

You're welcome and thanks for the rep!


If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.