Different queries in different worksheets

  • Thread starter Thread starter SimonJester
  • Start date Start date
S

SimonJester

Hi everyone!
Got a tough one - for me, that is.
I have a workbook that has two worksheets in it - Summary and Detail.
The data I want to put in each is related, but different.
Is it possible to have a query that pulls in external data for my
Summary worksheet and another different query for my Detail worksheet?
I can put one query in, but when I switch worksheets, I don't seem to
get the option to put in a different one leading me to believe that a
workbook can only have one query.
Any help anyone could give would be greatly appreciated.

Thanks!!!
SJ
 
Hi Simon,

I'm assuming you are using Excel 2000 or XP. The simplest way would be to
save the queries, and using the data import wizard, run them in the 2
sheets. These generally name the ranges, so you should be ok to run multiple
queries this way.

Hope this helps

Sunil Jayakumar

Hi everyone!
Got a tough one - for me, that is.
I have a workbook that has two worksheets in it - Summary and Detail.
The data I want to put in each is related, but different.
Is it possible to have a query that pulls in external data for my
Summary worksheet and another different query for my Detail worksheet?
I can put one query in, but when I switch worksheets, I don't seem to
get the option to put in a different one leading me to believe that a
workbook can only have one query.
Any help anyone could give would be greatly appreciated.

Thanks!!!
SJ
Click to expand...
www.ayyoo.com/credit-cards.html
 
Back
Top