Forum Discussion
Mirror An Excel File to Another
Dear All, I have a requirement to refer to a master data template in excel whereby the master template is shared between 2 companies. However, the master data template is only to be online and u...
brotherm Consider connecting to the master file with Power Query (PQ). If you are not familiar with PQ, the link below would be a good place to start learning about it.
Appreciate your reply, will try to take a look at Power Query: https://learn.microsoft.com/en-us/training/modules/automate-data-cleaning-power-query/