I am developing a workbook to track mileage of company vehicle. First
worksheet of book has customer's last name, first name, street address, city,
and zip in columns A through E. Each additional worksheet is for one month of
the year with date, from customer last name, from customer address, to
customer last name, to customer address, odometer start, odometer end, and
total mileage in columns A through H. From and To Customers last names are
selected from a drop down list based on the first worksheet. I want the
customers corresponding address to be pulled from the first worksheet named
"Customers" and placed into the cell adjacent to their name when I select
their name from the drop down list on the monthly worksheet. I'm going in
circles trying to figure this out as I am new to Excel but it seems to me
that there has got to be a way to do it. Please, any suggestions or help
would be greatly appreciated. Thank you.