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