User Profile
SarahD26
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Summary Sheet for Employee Names wit the Text of Their Location Reported on Summary Sheet
I have 7 sheets with the same employee names for shared employees. Each project manager fills out their sheet with their jobs and what people they want. Next to that employees name they will enter the jobs site "123" they are working at. I want the master summary sheet to look to each individual sheet and report the job site "123" if they find text in that cell or if it finds a site listed on more than one worksheet and error so they know a discussion has to be had. This is a daily worksheet. I wanted to us XLOOKUP but I don't know how to combine each of the tabs to search for a dynamic set of changes job site values. Basically I need it to vlookup with Thanks for pointing me in the right direction!1.8KViews0likes5Comments
Groups
Recent Blog Articles
No content to show