Querying master worksheet

[Kayda]

Hi:

I have a master worksheet that runs from an Access query. After it is
populated I want the other sheets to be populated dynamically. So like
this:

WorksheetA
ColumnA ColumnB ColumnC
Agent Supervisor Calls
b. smith 1199 3
s. jones 1199 6
a. sharma 2244 4
a. chong 2244 5

WorksheetB
Header: Supervisor Number: 2244
ColumnA ColumnB
Agent Calls
a.sharma 4
a.chong 5

So basically each worksheet brings back a different supervisor. I know
this is basic stuff, but I'm pretty new to do anything slightly
complex with Excel. What is the best way to "query" the first
worksheet and bring back a result set? Basically it would look at the
value for the supervisor in the header cell and then populate several
columns from the main sheet based on that.

Thanks,
Kayda

 

[Guest]

hi,
what method are you using to bring the access query into excel?
Microsoft Query? other?
regards
FSt1