Forum Discussion
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!
Hi SarahD26,
the best solution would be doing this with PowerQuery, you can Keep you daily file in folder lookup the site number 123
This video might be helpful, but you need to group you data to do the count on"123" site number..
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
ExcelExciting Thanks! Does Microsoft Team allow PowerQuery to function fully? My understanding is Team and macros do not function fully together. Thanks for any insight!
Teams is actually Excel Online. All what is available in the latest you may see in Teams, that's just another interface in this case.
ExcelExciting Is there a max number rows power query can combine? Thanks
