Hello,
I have a spreadsheet of 7 columns (A-G) and can have varying amounts of rows (in the 1000's). The first column is a list of client names "LASTNAME, FIRSTNAME." Each employee has a caseload assignment based on the last name of the clients. So one employee has all the "C's" and another has all the "H's" and so on. But some employees have more complicated ALPHAs such as "RAA-REA" and some have even more complicated like "COR-CUT, GRE-GUZ, and MON-MY." Stupid right? An to make things worse, these assignments get changed about every six months.
So what I need is some VBA that separates this list into different sheets based on the ALPHA rules. Which also need to be changed every once in awhile. Each tab also needs to be named the name of the employee assigned to each ALPHA rule. Any ideas???
I have a spreadsheet of 7 columns (A-G) and can have varying amounts of rows (in the 1000's). The first column is a list of client names "LASTNAME, FIRSTNAME." Each employee has a caseload assignment based on the last name of the clients. So one employee has all the "C's" and another has all the "H's" and so on. But some employees have more complicated ALPHAs such as "RAA-REA" and some have even more complicated like "COR-CUT, GRE-GUZ, and MON-MY." Stupid right? An to make things worse, these assignments get changed about every six months.
So what I need is some VBA that separates this list into different sheets based on the ALPHA rules. Which also need to be changed every once in awhile. Each tab also needs to be named the name of the employee assigned to each ALPHA rule. Any ideas???
