Having data source and query code issues....

[Guest]

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.

 

[Gord Dibben]

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