I have a vehicle auction 4 times a year. I need to create an excel sheet that has a drop down list for the vehicles and the buyers. This will be used to auto populate the data from both the buyer and vehicle information into a printable bill of sale. The buyers will be in a drop down list as their bidder number 105,110,115,120 etc... The vehicles will be in a drop down list as the auction number 1,2,3,4 etc...
I need to be able to select the vehicle and have it add yr, make, model, color & VIN. Then select the bidder # and have it enter the name, address, phone etc...
I can create a drop down list but cannot make it populate the extra data into the other cells.
Bookmarks