SQL with Excel ranges

  • Thread starter Thread starter Arshavir Grigorian
  • Start date Start date
A

Arshavir Grigorian

Hi,

I would like to be able to select a set of Excel cells, name them,
then write VBA code to filter the range based on certain criteria -
essentially treat the range as a database table and run an SQL on it
returning a set of rows that match the criteria (the SQL WHERE
clause). Is it possible to do such a thing and if so how should I go
about coding it? DAO? I think I can simply loop through the range and
filter rows through an IF() statement, but I am thinking there is a
better way ...

Thanks.
 
Back
Top