<div>
Would be helpful if you can upload a dummy workbook with some sample data in it and mock up the desired output manually.
</div>


Would be helpful if you can upload a dummy workbook with some sample data in it and mock up the desired output manually.

<div>
<div class="content wysiwyg-content">
Hey all,<br />
<br />
This may be a simple answer, but i am just not having any luck. I am trying to create a sale quote spreadsheet that some of my sales guys can use... I have done a ton of work but now what I trying to do is auto fill the hard item cost depending on what item they select. I have created defined name ranges with the items on one side and the prices in the column next to it... I am trying to use data validation to create a drop down menu, then from that menu they select the item they want. In the column right next to that choice it would auto fill the price from the defined name range... Any help?<br />
<br />
Thank you!
</div>
</div>


Hey all,

This may be a simple answer, but i am just not having any luck. I am trying to create a sale quote spreadsheet that some of my sales guys can use... I have done a ton of work but now what I trying to do is auto fill the hard item cost depending on what item they select. I have created defined name ranges with the items on one side and the prices in the column next to it... I am trying to use data validation to create a drop down menu, then from that menu they select the item they want. In the column right next to that choice it would auto fill the price from the defined name range... Any help?

Thank you!

Excel Sales Quote Workbook name range, data validation help

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.