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