Michael Katz
asked on
2 different sql queries inside 1 excel worksheet...
Hi Experts,
I have an Excel workbook with several worksheets.. Each worksheet is using an SQL Query with a Cell as a Filter.. (data is entered into a cell and presto the data is refreshed)
One of these worksheets needs to have an additional SQL Query added 2 rows after the 1st sql query data is displayed in worksheet.. this additional SQL Query will filter data on the cell that the first query has utilized..
Hopefully this makes sense
I have an Excel workbook with several worksheets.. Each worksheet is using an SQL Query with a Cell as a Filter.. (data is entered into a cell and presto the data is refreshed)
One of these worksheets needs to have an additional SQL Query added 2 rows after the 1st sql query data is displayed in worksheet.. this additional SQL Query will filter data on the cell that the first query has utilized..
Hopefully this makes sense
ASKER
Yes..exactly
ASKER
Yes I have exactly what your are doing.. The problem is getting the 2 seperate sql queries that are written in microsoft query to show...I can only create 1 sql query per worksheet
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect response.. Thank you
Do you mean that the 2nd query is using a parameter, and that parameter comes from the cell filled by the 1st query?