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 th...
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.
