How do I move data into tabs based on a value in a column?

[skm4hfh]

I have listed category types for employees in a column (like P for patchwork and T for tapers). I want to move those employees from a master into individual tabs for each category.

 

[SkipVought]

Hi,

I would not move ANYTHING. You already have some of your data in a structure that is most useful. It may be ok to REPORT the data in separate tabs. That could be done using the PivotTable Wizard. Personally, I would not go the that bother.

Rather apply the AutoFilter to your table, and filter the category by each value. It accomplishes much the same purpose.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}