Home

Excel Format for a Courier company

Highlighted
Ubaid Ullah null
Occasional Visitor

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.

1 Reply

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.

 

Related Conversations
Copy/paste no longer working in Excel
Jon Firooz in Excel on
70 Replies
Mouse right click pop-up menu stopped working in Excel 2013
Emil Garnev in Excel on
7 Replies
Date Formatting in a Pivot Table
Lorrie Griffin in Excel on
3 Replies
Security Warning: Automatic update of links has been disabled.
Mark Adams in Excel on
6 Replies
EXCEL DO NOT SHOW GRAPH MAP CHART
Mark 777 in Excel on
49 Replies