Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SIMPLE QUESTION need fast answer please | Excel Worksheet Functions | |||
Simple Question, But No Answer | Excel Worksheet Functions | |||
Quick answer please! | Excel Worksheet Functions | |||
Another Quick Simple VBA question (if...then statement) | Excel Programming | |||
simple question, hopefully a simple answer! | Excel Programming |