I have a sheet that contains a list of UPC I want to query the
database and build this report using excel. The report is simple but
is driven off of the list of UPCs is their a way I can write this
without a lot of VBA work?

I was hoping that by the time Excel 2003 came out that SQLwould be
able to interact with cells

Something like

Select * FROM Product WHERE UPC11 IN(=IN('Product List'!A:A))

or
something simple like that


It has been about 5 years since I have touched VBA so I would prefer
an alternative approach.