Query from within Excel

I have a need for some query help and I will try to explain my situation.
Thanks in advance for any help.
I have an Excel spreadsheet that has two different sheets. One one sheet
called "Data" I have created a query that pulls AP Invoices from from a SQL
database. In the results of this query I may have several lines with the
same Company.
Ok here's my question. On my other sheet page of the same file, is there
any way to run a Select statement and use the "Data" sheet as the FROM
Source?
I know this is very confusing, I just hope someone can decipher what I have
written.you can do it directly via vba. No need to access via oledb.
"Preacher Man" <nospam> wrote in message
news:O6zqUCfJGHA.1424@.TK2MSFTNGP12.phx.gbl...
>I have a need for some query help and I will try to explain my situation.
>Thanks in advance for any help.
> I have an Excel spreadsheet that has two different sheets. One one sheet
> called "Data" I have created a query that pulls AP Invoices from from a
> SQL database. In the results of this query I may have several lines with
> the same Company.
> Ok here's my question. On my other sheet page of the same file, is there
> any way to run a Select statement and use the "Data" sheet as the FROM
> Source?
> I know this is very confusing, I just hope someone can decipher what I
> have written.
>