I have a long list of automobiles in many different spread sheets.
I have all these cars numbered!
I want to be able to make a work order sheet that the first cell is asking
for a car number, then to fill the rest of the cells based on the input car
number!!
AS an example the cells I have are
car number, year, make, model, vin number
When a person writes up the work order I want them to be able to just put
car number and have all the rest of the fields filled on that number can
anyone help!!!!@