Hello everyone,
I am in the military currently in Afghanistan trying to create a excel spreadsheet that will calculate miles. I would like for it to simultaneously create a visual chart showing the work from each location to each location. I have included an example spreadsheet with make believe numbers and letters. I just need the formula so that I could apply it to my chart but if you can use the example chart well than a picture is worth a thousand words.
Example of what I would like for it to do:
1. Click on beginning location in this case it will be any place between A2 thru A20. (Automatically creates a Start Point SP) in A22
2. Click on any destination between B1 thru T1 (Automatically populates A23 with (name) and B23 the miles it takes to get to said location).
3. Click on follow on destination also between B1 thru T1 (Automatically populates A24 with (name) and B24 the miles it takes to get to said location) and so on and so on.
4. Finally the total will be displayed always in B41 the number changing as you click from destination to destination to destination.
I would very much greatly appreciate any assistance on this matter.
Bookmarks