Generating Separate Sheets from Pivot Table Data

So what I'm looking to accomplish is to be able to take the pivot table in the first tab and automatically generate tabs 2-4. Tab 5 is the raw data underlying the pivot.

My job involves allocating time for employees, so often we have data in the form you see in the 1st tab and then need to manually separate it by supervisor into separate tabs (as can be seen in tabs 2-4).

I'm curious if there is a VBA method that could optimize this process.

Thanks!

Always the same company?

Originally Posted by qzqzjcjp

Always the same company?

Sometimes you're dealing with multiple companies.

Originally Posted by qzqzjcjp

I am new in VBA, but I tried to help you. The attachment is my test. There must be a blank tab in advance.


Attachment 344554

It works! Thanks a lot man. You're a budding VBA star.

You are welcome! Please mark it as solved. Thanks!