moving data between workbook sheets

[Soosieboo]

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.

 

[Don Guillett]

Before you go to all that trouble, are you aware of
Data>filter>autofilter>>>

 

[Soosieboo]

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

 

[Don Guillett]

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.