Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Separate Variable Range of Data into Different Worksheets
I have a single worksheet with example data as shown:
A1 B1 C1 Name Job Manager John S. Super Bill Sue M. Analyst Bill Jack V. Clerk Bill Gary W. Sr Analyst Lisa Bob N. Clerk Lisa Tim B. Super Phyllis Z. Nate M. Clerk Phyllis Z. John Q. Clerk Phyllis Z. Quin L. Analyst Phyllis Z. Paul S. Analyst Phyllis Z. Each manager has a varying number of employees. I need to create a new worksheet for each manager (in the same workbook) containing all the manager's employee's (and their Job). Thus the final product will be a workbook with 4 worksheets: 1 with original data, 3 containing each manager's employees. How would I do this using VBA? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Separate raw data onto different worksheets | Excel Worksheet Functions | |||
Show Data In Range not appearing in Separate Range | Excel Discussion (Misc queries) | |||
Applying range names to existing formulas in separate worksheets | Excel Discussion (Misc queries) | |||
Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
Compare data on 2 separate worksheets. | Excel Worksheet Functions |