Simple Question, need quick answer please

[Stevie_mac]

Is there a way - in excel, to run SQL like queries on a sheet of data within the same workbook

E.g.
Sheet1 has data
In sheet 2, macro runs "SELECT * FROM Sheet1 WHERE Sheet1.Col1 <> 5"

I know there is ways to simulate this (by looping data) but I need to do several different parameterised queries

Thanks in advance.

 

[Bob Phillips]

You can use ADO to look at sheets within a workbook, but this can only be on
a file saved to disk, not the open workbook. It can be the same workbook as
the open one, but it will look at the saved version.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Is there a way - in excel, to run SQL like queries on a sheet of data within the same workbook

E.g.
Sheet1 has data
In sheet 2, macro runs "SELECT * FROM Sheet1 WHERE Sheet1.Col1 <> 5"

I know there is ways to simulate this (by looping data) but I need to do

several different parameterised queries