Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having data source and query code issues....
This should be very simple... I think I am pulling a blonde moment!
I am creating a quote template for my husband in excel. I set up a master products table (spreadsheet) as my data source so he can change all of his numbers in one location only. I then created a sheet for the actual quote where I am using dropdownlists (ddls) based from this source for him to select a product and then I want to have the number fields fill automatically based on the product selected. Simple enough I have done it a million times with SQL tables. But where do I write my SQL code to query my datasource for the ddl ... I am not used to writing code for excel. The syntex is different and locations seem to be funky! Thanks in advance for pointing me in the write directin. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having data source and query code issues....
You can do this without programming.
VLOOKUP formulas will pull the data to appropriate cells. See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Sun, 4 Nov 2007 10:58:00 -0800, Samantha wrote: This should be very simple... I think I am pulling a blonde moment! I am creating a quote template for my husband in excel. I set up a master products table (spreadsheet) as my data source so he can change all of his numbers in one location only. I then created a sheet for the actual quote where I am using dropdownlists (ddls) based from this source for him to select a product and then I want to have the number fields fill automatically based on the product selected. Simple enough I have done it a million times with SQL tables. But where do I write my SQL code to query my datasource for the ddl ... I am not used to writing code for excel. The syntex is different and locations seem to be funky! Thanks in advance for pointing me in the write directin. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup issues when source data is in another workbook? | Excel Discussion (Misc queries) | |||
Change data source for MS Query | Excel Discussion (Misc queries) | |||
Data Source Trust Issues | Excel Discussion (Misc queries) | |||
Data Source for MS Query | Excel Discussion (Misc queries) | |||
query source code | Excel Programming |