Forum Discussion

Copper Contributor

Mar 19, 2020

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

excel

ExcelExciting

MVP

Mar 20, 2020

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

https://youtu.be/F5fjv6nXvZo

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

SarahD26
Copper Contributor
Mar 20, 2020
ExcelExciting Is there a max number rows power query can combine? Thanks
- ExcelExciting
  MVP
  Mar 20, 2020
  SarahD26, it can handle n number of rows from multiple sources..
  
  Regards, Faraz Shaikh
SarahD26
Copper Contributor
Mar 20, 2020
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!
- SergeiBaklan
  Diamond Contributor
  Mar 20, 2020
  SarahD26
  
  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.