Filter,. Create a new file along with the pivot

[sreenivas501]

Hello,

Need your help to create a macro on the below query please.

In sheet 1, data is there from column A to U for multiple companies.
In sheet 2 there is a pivot table based on company-wise. So this is a consolidated file.


Now, what we want here is a separate file for each company. Meaning automatically create a separate files for each company with data file in sheet 1 and Pivot table in sheet 2.

The companies list may vary from 20 to 40 depends on the report we get. Please advise.


Thank you,
Srini