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...