Auto populate excel quotes from thousands of referenced price lists

copperheadjr

New Member
Joined
Jun 4, 2015
Messages
1
Hello,

I am trying to determine if there is a way to create a workbook template for a sales quote that references other workbooks. In other words, is there a way to automate the population of data fields (eg. supplier, cost, description) when a manufacturer product number is entered into a field. Essentially, I would like automate the quote building process by creating a workbook template that draws supplementary data (supplier, cost, description) from reference workbooks to match an entered manufacturer product number.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,102,305
Messages
5,486,072
Members
407,531
Latest member
WalterR01

This Week's Hot Topics

Top