I am trying to use excel to track my customer information and auto generate quotes that I can save.
I have 1 sheet that has columns labelled:
Customer Number, Customer Name, Customer Phone, Customer Email, Customer Address, Customer City, State, and Zip.
I have a second sheet that is an excel template for a customer quote:
I am trying to auto fill the rows labeled Customer Name, Customer Phone, Customer Email, Customer Address, Customer City, State, and Zip once I type in the Customer Number, which will also be the Quote number.
So basically I am trying to say When the quote number in sheet 2 is the same as the customer number in sheet 1, Auto Fill the Cells in sheet 2 with the information in columns 2,3,4,5,6,7,8 in sheet 1.