Hi, Its Ubaid. I am running a courier company. But I am facing issues in putting data in multiple forms. The procedure is: Packages come from large number of customers and are being shiped to different teams in different cities. Is it possible in Excle to enter data in one file and this data is automatically located to the rest of customers and teams file. Guide me please. Thank you so much.
I would not use Excel to collect the data for that scenario. I recommend taking a look at Power Apps to create an app for people to enter the data, once the data has been collected and stored in an appropriate database, (possibly provided by the Common Data Service) then you can use Excel to link to the data store so that you can peform additional calculations. you may also want to use Power BI to create reports/dashboards with maps.