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.
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.
