Hi,

Newbie here.
I want to use excel to create quotations for customers. (currently doing it in word)
Tab 1 is the quote, has 4 columns, part number, description, cost, yearly maintenance
Tab 2 has all the things we sell, part number, description, cost, yearly maintenance. 150 lines.

So, Tab 1, description column is a drop down box from Tab 2. Working fine.

Question.
When an item is selected from the drop down, how do I get it to then bring from tab 2 the part number, cost and yearly maintenance.

Thanks in advance !

Rothers