auto fill

[niyrho]

On sheet 1 I have a work order with the customer name, address, phone and account #. On sheet 2 I have a list of customers. If you start to fill out the work order with customer info that's already in the list on sheet 2 I want it to fill in the rest automaticly. If its not on the list I want it to act normal.

[mdmackillop]

Have a look at the attached workbook. Uses Data Validation with Sheet Change event.