ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,699
- Office Version
- 2007
- Platform
- Windows
I enter my mileage onto a spreadsheet for various garages.
I wish to have a drop down list with the garages name & miles to & from there.
In the drop down list i would need to see the name of the garage & also the miles BUT when i make my selection i would only require the mileage to be entered into the cell.
The worksheet is called MILEAGE & the drop down list will be placed into cells D3:D30
Is this possible if so please advise.
Many thanks.
I wish to have a drop down list with the garages name & miles to & from there.
In the drop down list i would need to see the name of the garage & also the miles BUT when i make my selection i would only require the mileage to be entered into the cell.
The worksheet is called MILEAGE & the drop down list will be placed into cells D3:D30
Is this possible if so please advise.
Many thanks.