Hello Everyone ,
I need help with some VBA programming.
Attached is excel sheet.
What I have
- worksheet "mastersheet" has names of all the people working in a site
- 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
- To have a code that looks for each engineers name in Range A5:A15 from Mastersheet in each worksheet
- 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
Bookmarks