Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

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?

Re: Building a quote sheet

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

Re: Building a quote sheet

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.