hello every one
I have many data in sheet1 it design by table what I want split the tables based on column b in sheet1 and based dropdown in b1 in sheet2 it should show divided tables in sheet2
and if there is b1 is empty then split all of data to many tables with considering every time I select the in b1 in sheet1 it should copy to the bottom
sheet1
if select in b1 in sheet2
if clear b1 in sheet2 the result should this
I have many data in sheet1 it design by table what I want split the tables based on column b in sheet1 and based dropdown in b1 in sheet2 it should show divided tables in sheet2
and if there is b1 is empty then split all of data to many tables with considering every time I select the in b1 in sheet1 it should copy to the bottom
sheet1
DATE | CODE | MODEL | ORIGIN | BRAND | QUANTITY |
01/01/2020 | AA-OIL | CASTROL | EU | 10-W40 208L | 240 |
01/02/2020 | AA1-OIL | CASTROL | EU | 10-W40 1L | 123 |
01/03/2020 | AA2-OIL | CASTROL | EU | 10-W40 4L | 1233 |
01/04/2020 | BB-OIL | ENI | EU | 10-W40 208L | 123 |
01/05/2020 | BB1-OIL | ENI | EU | 10-W40 1L | 122 |
01/06/2020 | BB2-OIL | ENI | EU | 10-W40 4L | 111 |
01/07/2020 | AA-OIL | CASTROL | EU | 10-W40 208L | 10 |
01/08/2020 | AA1-OIL | CASTROL | EU | 10-W40 1L | 22 |
01/09/2020 | BB1-OIL | ENI | EU | 10-W40 1L | 122 |
01/10/2020 | BB2-OIL | ENI | EU | 10-W40 4L | 111 |
01/11/2020 | CC1-OIL | Q8 | EU | 10-W40 208L | 123 |
01/12/2020 | CC2-OIL | Q8 | EU | 10-W40 4L | 124 |
01/13/2020 | CC3-OIL | Q8 | EU | 10-W40 1L | 125 |
if select in b1 in sheet2
CODE | AA-OIL | ||||
DATE | CODE | MODEL | ORIGIN | BRAND | QUANTITY |
01/01/2020 | AA-OIL | CASTROL | EU | 10-W40 208L | 240 |
01/07/2020 | AA-OIL | CASTROL | EU | 10-W40 208L | 10 |
TOTAL | 250 | ||||
if clear b1 in sheet2 the result should this
CODE | |||||
DATE | CODE | MODEL | ORIGIN | BRAND | QUANTITY |
01/01/2020 | AA-OIL | CASTROL | EU | 10-W40 208L | 240 |
01/07/2020 | AA-OIL | CASTROL | EU | 10-W40 208L | 10 |
TOTAL | 250 | ||||
DATE | CODE | MODEL | ORIGIN | BRAND | QUANTITY |
01/02/2020 | AA1-OIL | CASTROL | EU | 10-W40 1L | 123 |
01/08/2020 | AA1-OIL | CASTROL | EU | 10-W40 1L | 22 |
TOTAL | 145 | ||||
DATE | CODE | MODEL | ORIGIN | BRAND | QUANTITY |
01/03/2020 | AA2-OIL | CASTROL | EU | 10-W40 4L | 1233 |
TOTAL | 1233 | ||||
DATE | CODE | MODEL | ORIGIN | BRAND | QUANTITY |
01/04/2020 | BB-OIL | ENI | EU | 10-W40 208L | 123 |
TOTAL | 123 | ||||
DATE | CODE | MODEL | ORIGIN | BRAND | QUANTITY |
01/05/2020 | BB1-OIL | ENI | EU | 10-W40 1L | 122 |
01/09/2020 | BB1-OIL | ENI | EU | 10-W40 1L | 122 |
TOTAL | 244 | ||||