In worksheet 1, column B, I have a drop down list to choose from a number of customer numbers listed in worksheet 2. When the customer number is chosen from the dropdown list, I want the address info from from worksheet 2 columns C,D,E, F,G to be copied to the worksheet 1 columns C,D,E ,F, G. I know it can be done but I can't figure out how. Help?