I run stats for my team each week and populate a workbook with the results
for each agent. I would then like to move the line for each agent into an
individual page for each person.
I know I can copy/paste it but it is time consuming. I would like to
automate it to some degree and I don't know where to start.
--
Soosieboo - excel novice

Before you go to all that trouble, are you aware of
Datafilterautofilter


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Soosieboo" wrote in message
...
I run stats for my team each week and populate a workbook with the results
for each agent. I would then like to move the line for each agent into an
individual page for each person.
I know I can copy/paste it but it is time consuming. I would like to
automate it to some degree and I don't know where to start.
--
Soosieboo - excel novice

yes i'm fine with that. If you can imagine, sheet 1 would be the weekly data.
This will change each week.
Line 1 to 15 (say) would have the stats for each agent in several columns.
I would like to move the individual lines to a sheet per agent which will
show their results week on week.

Hope i've made it clear..its not easy to explain without being able to point
to it..
--
Soosieboo - excel novice


"Don Guillett" wrote:

Before you go to all that trouble, are you aware of
Datafilterautofilter


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Soosieboo" wrote in message
...
I run stats for my team each week and populate a workbook with the results
for each agent. I would then like to move the line for each agent into an
individual page for each person.
I know I can copy/paste it but it is time consuming. I would like to
automate it to some degree and I don't know where to start.
--
Soosieboo - excel novice

If desired, send your workbook to my address below along with snippets of
these emails copied to a new worksheet along with a clear explanation, with
examples before/after, of what you want. I probably won't be able to look
until tomorrow.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Soosieboo" wrote in message
...
yes i'm fine with that. If you can imagine, sheet 1 would be the weekly
data.
This will change each week.
Line 1 to 15 (say) would have the stats for each agent in several columns.
I would like to move the individual lines to a sheet per agent which will
show their results week on week.

Hope i've made it clear..its not easy to explain without being able to
point
to it..
--
Soosieboo - excel novice


"Don Guillett" wrote:

Before you go to all that trouble, are you aware of
Datafilterautofilter


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Soosieboo" wrote in message
...
I run stats for my team each week and populate a workbook with the
results
for each agent. I would then like to move the line for each agent into
an
individual page for each person.
I know I can copy/paste it but it is time consuming. I would like to
automate it to some degree and I don't know where to start.
--
Soosieboo - excel novice