i'm confused and not able to get a proper syntax on how to get the site name and work through multiple workbooks.

Sheet 1 where the data would be pasted - i want a site name to be populated there
sheet 2 is the employee details where there is a site code. There can be multiple employees - so i guess there comes one loop.
sheet 3 is the sheet where i have the site code to site name info - again there are multiple sites so comes the other loop

So from sheet 2 for a particular employee it should consider the site code than go to sheet 3 get the value of site name and return that value to sheet 1

the below code is just the part that im trying to get the site name - there are other things that i populate directly from sheet 2. But site code is where i have problem. P.S. the below code is already inside a loop - as its populating other fields

Please Login or Register  to view this content.
can someone help me in getting the syntax corrected