J
jsw
Hi.
I am trying to produce a drop down list for my mileage records.
Basically, I have locations A,B,C,D with their mileage in the next cell ie
10,20,30,40.
On my main sheet I want to be able to select the locations from a drop down
box and excel fill in the location and associated mileage in two cells.
I can easilly use 2 drop down boxes for locations and mileage but this means
I have to remember how far it is to each location.
ANy help on how to do this?
Thnaks
I am trying to produce a drop down list for my mileage records.
Basically, I have locations A,B,C,D with their mileage in the next cell ie
10,20,30,40.
On my main sheet I want to be able to select the locations from a drop down
box and excel fill in the location and associated mileage in two cells.
I can easilly use 2 drop down boxes for locations and mileage but this means
I have to remember how far it is to each location.
ANy help on how to do this?
Thnaks