Querying master worksheet

  • Thread starter Thread starter Kayda
  • Start date Start date
K

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
 
hi,
what method are you using to bring the access query into excel?
Microsoft Query? other?
regards
FSt1
 
Back
Top