Dear All,
I do have a sample data set across A1:E20 as follows in the Sheet Name
UMP. Rows in this column could go upto 30000.
DUMP is the input sheet based on which multiple sheets need to be created.
In this scenario there are 2 unique count of categories namely FMCG & Staples.
So 2 different sheets need to be created with name of FMCG & Staples.
Sheet number will depend on the Unique count of categories under Column A in DUMP sheet and accordingly the sheet names will also be created.
Now under each sheet, that will be created from Column A, the summary in the different sheets would be as follows.
FMCG sheet should have the summary as follows:-
SKU should be sorted based on the total aggregated qty on descending mode as shown above.
Similarly Staples sheet summary should also be as follows:-
The tasks will be as follows:-
1)Creation of "N" number of sheets based on the Unique Count of Categories under Column A under DUMP sheet.
2)Sheet name would be based on the Category type mentioned in the Column A of DUMP sheet.
3) Every created sheet needs to contain a summary as shown above.
4)SKU needs to be sorted based on the total aggregated qty in descending mode.
Please help.
This would save substantial manual time being wasted now.
Regards
I do have a sample data set across A1:E20 as follows in the Sheet Name
DUMP is the input sheet based on which multiple sheets need to be created.
In this scenario there are 2 unique count of categories namely FMCG & Staples.
So 2 different sheets need to be created with name of FMCG & Staples.
Sheet number will depend on the Unique count of categories under Column A in DUMP sheet and accordingly the sheet names will also be created.
Now under each sheet, that will be created from Column A, the summary in the different sheets would be as follows.
FMCG sheet should have the summary as follows:-
SKU should be sorted based on the total aggregated qty on descending mode as shown above.
Similarly Staples sheet summary should also be as follows:-
The tasks will be as follows:-
1)Creation of "N" number of sheets based on the Unique Count of Categories under Column A under DUMP sheet.
2)Sheet name would be based on the Category type mentioned in the Column A of DUMP sheet.
3) Every created sheet needs to contain a summary as shown above.
4)SKU needs to be sorted based on the total aggregated qty in descending mode.
Please help.
This would save substantial manual time being wasted now.
Regards