Automating Mileage Form

mattyboy_1984

New Member
Joined
Nov 14, 2018
Messages
1
Hi, I am wondering if you are able to help me, I am trying to create an automated word documents which take its data from excel to calculate the mileage i travel between clients address just by entering there name, So i would enter client 1 to clients 2 and it would calculate how many miles it was, Is this possible?

I have provide a link to a copy of the mileage form

https://1drv.ms/u/s!AspGJVzkjW3Gj6gf5WeSYtwlJJsuMQ

thank you for you help
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,843
yes. You can fill the worksheet, then run a macro to put it in a word doc.
Build a template word doc., then the macro would open this template ,then import the excel sheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,412
Messages
5,414,261
Members
403,522
Latest member
Abel_excel

This Week's Hot Topics

Top