Making a quotation filled with data from a table on another worksheet

Copper Contributor

Good morning,

I haven't been using Excel a lot but I've found a template for a quotation that I want to upgrade. On the first sheet I have all the information that needs to come in the quote, and the second sheet I made a table with all items that could come in the quote. Description, quantity, my price, clients price.

 

No I've got the table at the point I can use it like I want but actually the prices that we sell for should be together with the description, so how can I use one pull down item and make the other colums, like price to follow?

1 Reply