ExcelBanter - automating a sales quote spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - automating a sales quote spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/17997-automating-sales-quote-spreadsheet.html)

automating a sales quote spreadsheet

My work has all of its inventory priced in excel. I added a sheet that is a
quote page. Now, I would like to find a way to automate the data from the
pricebook over to the quote page using drop down lists. I figured out how to
make lists using the data validation, but I want to be able to migrate the
pricing, description and model numbers from the price book to the quote page.
Can anyone help?

You could use the VLOOKUP Function with a table.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlFunctions02.html

Gord Dibben Excel MVP

On Wed, 16 Mar 2005 12:47:03 -0800, "TXTrailerdaddy"
wrote:

My work has all of its inventory priced in excel. I added a sheet that is a
quote page. Now, I would like to find a way to automate the data from the
pricebook over to the quote page using drop down lists. I figured out how to
make lists using the data validation, but I want to be able to migrate the
pricing, description and model numbers from the price book to the quote page.
Can anyone help?