S
S
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.
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.