Sort and add Sheet's help

[Mrbanner]

Hi All
Need some help.
I have about 8000 lines to sort on a daily basis via excel

What I need

I have A-P Colums across
And 8000 - 10,000 lines going down

Colum C= Sales person's Name
There is about 20 or different names
What I need is so that for Every sales person it creates a new Sheet
Called (Sales person's Name reps name new names added every day)


Then puts all the info from each line that has there name on it.
And it puts all info from Colum

Hope it makes Sense

 

[JAVB]

I'm not sure what you are needing. Does the 8000 - 10000 rows of dat
change daily? Do you want new sheets created each day for the sam
sales reps or data added to existing sheets is that sales rep alread
has a sheet and new sheets created if a new sales rep is added? Woul
the data need to be removed from the master sheet when added to th
sales reps sheet?

You would need to use visual basic to accomplish the above. Have yo
used visual basic before?

JAV

 

[Mrbanner]

WHAT i would like to do is
say every morning

Dump data into main sheet
Then it makes torep sheets
i print these out for each rep
then close file
No history needed to be kept

Maybe a marco or some thing ?