chem101
11-19-2010, 10:44 AM
Hello Everyone,
Is it possible to auto fill a cell from the drop down list attached to the cell from Data Validation. I a user that selects a Customer's Name from a drop down list attached to a cell in worksheet 1. The Customer List is a table set up in worksheet 3. I would like the user to enter a letter or two in the cell with the drop down list on worksheet one and have the name auto fill the Customer's Name. Can this be done with VBA code? If yes, can offer some advice on how I can begin.
Thank you!
Is it possible to auto fill a cell from the drop down list attached to the cell from Data Validation. I a user that selects a Customer's Name from a drop down list attached to a cell in worksheet 1. The Customer List is a table set up in worksheet 3. I would like the user to enter a letter or two in the cell with the drop down list on worksheet one and have the name auto fill the Customer's Name. Can this be done with VBA code? If yes, can offer some advice on how I can begin.
Thank you!