Building a quote sheet
Posted by Dargan Baldwin on January 15, 2002 1:31 PM
I am trying to build a quote workbook to figure and print job quotes for a business. I have a product price list in Access and am trying to use it in conjunction with excel. What I would like to happen is that when you type in a product ID in the ProductID cell that a description cell and cost cell would auto fill from the database. Any help out there for this problem?
Posted by Chris D on January 15, 2002 1:40 PM
I know that a data validation list may be defined by a
name that point to a specific range within the same workbook or sheet. Is there anyway to do this also from another workbook?
Case is that a user, when activating a template file, should be given the option to select one person name from a data-validation-list, and then via VLOOKUP get the full address info from the "address.xls". The person names are first coulum in "address.xls".
Posted by Nate Oliver on January 15, 2002 4:31 PM
Not quite autofill but close....Click on a cell and select data->get external data->new database query
from there you build a query similar to one in Access. You can make your query paramter a link to an input cell as you described.
Once it's built, you type in what you please, right-click in the query body and select 'refresh data.' You can also record yourself refreshing if you'd like to build a macro with this.
Cheers!
Nate
