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
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