I do have a master Sheet Named DUMP which have 10 Columns in it. The sample is as follows across A1:J9

I want to create multiple sheets from this dump sheet based on the following conditions:-

1)Number of sheets will be based on the Unique Count of DCs(Under Column:-F). Here in this scenario, the no of sheets will be 4 since there are 4 Unique count of DC Codes under Column:-F.

2)Each populated Excel Sheets will also have the same sequential Column Headers as present in the DUMP Sheet & further it should have the details only pertaining to the DC Codes.

3)Sheet Names will be based on the DC Codes(Column:-F).

4)Finally, in every populated Excel Sheet, the qty needs to be sorted on the descending order(Column:-I).

Pls help.

Input:-

Delivery | SKU | Article Description | PGr | Created on | DC | Ship-to | STO Number | Qty | Value |

q | 1 | 1q | z | 25-Jan | a | z | 10 | 2 | 100 |

w | 2 | 2w | x | 26-Jan | b | x | 20 | 3 | 200 |

e | 3 | 3e | c | 27-Jan | c | c | 30 | 4 | 300 |

r | 4 | 4r | v | 28-Jan | d | d | 40 | 5 | 400 |

t | 5 | 5t | b | 29-Jan | a | e | 50 | 6 | 500 |

y | 6 | 6y | n | 30-Jan | a | r | 60 | 7 | 600 |

u | 7 | 7u | n | 30-Jan | b | t | 70 | 8 | 700 |

i | 8 | 8i | m | 30-Jan | c | y | 80 | 9 | 800 |

Desired ResultOne Sheet for DC:-a)(Sheet Name=a)

Delivery | SKU | Article Description | PGr | Created on | DC | Ship-to | STO Number | Qty | Value |

y | 6 | 6y | n | 30-Jan | a | r | 60 | 7 | 600 |

t | 5 | 5t | b | 29-Jan | a | e | 50 | 6 | 500 |

q | 1 | 1q | z | 25-Jan | a | z | 10 | 2 | 100 |