Look at my answer to the post of 2 December 2005:
Count duplicates in an array?

RBS


"agustina_s" wrote
in message ...

Hi is there anyway to create macro/ VBSCript to execute SQL Select
statement in Excel Column.

Eg.

Select FirstName where LastName in ('Smith','Anderson')

I have an excel spreadsheet1 with Column A = FirstName and B =
LastName
And then in another spreadsheet2 I want to look up value to
spreadsheet1.

Is there any tutorial regarding this?
I tried to search for it but to no avail :S.

Any suggestion is welcome.
Thanks in advanced.

Regards

Agustina


--
agustina_s
------------------------------------------------------------------------
agustina_s's Profile:
http://www.excelforum.com/member.php...o&userid=30094
View this thread: http://www.excelforum.com/showthread...hreadid=497813