Hello all, 

Am trying to automate data entry between separate Excels on teams. The scenario is I have 2 excels, let’s call them “Source” and “Consolidated”, my users will fill the information in “Source”, and I want it to auto populate into “Consolidated” to save time instead of manually copy pasting.

Currently I have a workaround to sync the “Source” sheet on Onedrive/sharepoint, and the “Consolidated” file just uses a “=” cell reference to pull up the necessary. It seems to work as long as we manually press sync and update, but am wondering if there is a better way to do it please?

Additionally (stretch goal), if there were multiple “Source” files, could “Consolidated” take reference to all of them and autopopulate as well?

Thank you!

P.s below is the few links I took reference to for the current method

https://support.microsoft.com/en-us/office/sync-sharepoint-and-teams-files-with-your-computer-6de9ede8-5b6e-4503-80b2-6190f3354a88

https://answers.microsoft.com/en-us/msoffice/forum/all/mirror-new-entries-in-teams-workbook-into-another/d53c5c07-809f-446a-850a-f2e67dfc376d

https://www.summarypro.co.uk/blog/excel-drawing-information-from-sharepoint-files.aspx

​Hello all,  Am trying to automate data entry between separate Excels on teams. The scenario is I have 2 excels, let’s call them “Source” and “Consolidated”, my users will fill the information in “Source”, and I want it to auto populate into “Consolidated” to save time instead of manually copy pasting. Currently I have a workaround to sync the “Source” sheet on Onedrive/sharepoint, and the “Consolidated” file just uses a “=” cell reference to pull up the necessary. It seems to work as long as we manually press sync and update, but am wondering if there is a better way to do it please? Additionally (stretch goal), if there were multiple “Source” files, could “Consolidated” take reference to all of them and autopopulate as well? Thank you! P.s below is the few links I took reference to for the current method https://support.microsoft.com/en-us/office/sync-sharepoint-and-teams-files-with-your-computer-6de9ede8-5b6e-4503-80b2-6190f3354a88 https://answers.microsoft.com/en-us/msoffice/forum/all/mirror-new-entries-in-teams-workbook-into-another/d53c5c07-809f-446a-850a-f2e67dfc376d https://www.summarypro.co.uk/blog/excel-drawing-information-from-sharepoint-files.aspx  Read More

​