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.