I am new to the forum as well a noob to Excel.
See my attached file of what I want to accomplish...I need help with VB code to insert my selected km's from a drop down menu.
The drop down menu have cities called "from" and "to"
Kilometers I have to ad manually,which I have no problem with,my only problem is if all the data is in my millage sheets I want to select two cities which in return will give me the difference in kilometers and that kilometer's eg( 9 km) will go automatically in my report.
Any help would be appreciated.
Thanks in advance