ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using the cells to buyild the query (https://www.excelbanter.com/excel-discussion-misc-queries/197655-using-cells-buyild-query.html)

S

Using the cells to buyild the query
 
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.



All times are GMT +1. The time now is 03:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com