This is probably simple but I need help.
I have a Workbook, on Sheet 2 of the workbook I have a list of businesses and the round trip mileages from our store.
On Sheet 1 I have the Date, a Dropdown List of the businesses on Sheet 2 and the Round Trip Mileage.
I want the Round Trip Mileage from Sheet 2 to automatically insert on Sheet 1 when I choose the business from the Dropdown list on Sheet 1.
I cannot figure this out. The file is attached.
Bookmarks