Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I use Excel as a simple database for Quoting?
I have a price list written up in excel adn want to tap into it for quick
quoting purposes but do not know how. 1. I want to have a scroll down box for the product type 2. Then the next cell to have a scrol down box for all the items in that product range. 3. Then when selecting the item the price and other attributes will pop up. I know how to use V-Look up - but not to filter the items via the first product type. I have tried to use validation - lists but my dtabase is on another sheet / file. I just need the one or two functions to use Please help with a finger in the right direction. Many thanks Stefan |
#2
|
|||
|
|||
You can create dependent data validation lists. There are instructions he
http://www.contextures.com/xlDataVal02.html The source list can be on a different sheet, if the range is named: http://www.contextures.com/xlNames01.html Stefan wrote: I have a price list written up in excel adn want to tap into it for quick quoting purposes but do not know how. 1. I want to have a scroll down box for the product type 2. Then the next cell to have a scrol down box for all the items in that product range. 3. Then when selecting the item the price and other attributes will pop up. I know how to use V-Look up - but not to filter the items via the first product type. I have tried to use validation - lists but my dtabase is on another sheet / file. I just need the one or two functions to use Please help with a finger in the right direction. Many thanks Stefan -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query a Access database that has a module from Excel | Excel Discussion (Misc queries) | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
How do I convert an existing MS Excel worksheet tracking a simple. | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |