Hi
I am trying to run an extract based on a range of products within excel.
I have used an odbc link but criteria remains static, looking all options up I need to write VBA to create a string based on the range and combine it to the sql
my vba is limited to autofilters, pdfs and sorting this is another level up
The range is sheet1 column A cell 2 down
my sql is
select *
from Master_Table MT
where MT.PARTNO IN (“cell range from sheet1 in spreadsheet”)
AND MT.FAC_CD = 'XX'
any help or pointer much appreciated
Cheers
Dan
I am trying to run an extract based on a range of products within excel.
I have used an odbc link but criteria remains static, looking all options up I need to write VBA to create a string based on the range and combine it to the sql
my vba is limited to autofilters, pdfs and sorting this is another level up
The range is sheet1 column A cell 2 down
my sql is
select *
from Master_Table MT
where MT.PARTNO IN (“cell range from sheet1 in spreadsheet”)
AND MT.FAC_CD = 'XX'
any help or pointer much appreciated
Cheers
Dan
