Hello Friends,
I need a VBA code for the following... there is some data in the sheet "DATABASE"
FIRST PART
I want all the above mentioned data for all 3 named ranges in a sheet "Supplier Wise" & sheet "Year Wise" starting from ROW 11 & COLUMN B:D
1) with removing duplicates keeping in mind all 3 columns
2) with sorted data as below
orders_qualitys = Order:=xlAscending
then by orders_articless = Order:=xlAscending
then by orders_units = CustomOrder:="Set(s),Pc(s),Pair(s),Dozen(s)"
SECOND PART
I want all the above mentioned data for 2 named ranges in a sheet "Supplier Wise" & sheet "Year Wise" starting from LOOK AT LAST USED ROW FROM FIRST PART THEN LEAVE 5 ROWS EMPTY & COLUMN B & COLUMN D (here column C will remain empty)
1) with removing duplicates keeping in mind 2 columns
2) with sorted data as below
orders_articless = Order:=xlAscending
then by orders_units = CustomOrder:="Set(s),Pc(s),Pair(s),Dozen(s)"
I need a VBA code for the following... there is some data in the sheet "DATABASE"
FIRST PART
I want all the above mentioned data for all 3 named ranges in a sheet "Supplier Wise" & sheet "Year Wise" starting from ROW 11 & COLUMN B:D
1) with removing duplicates keeping in mind all 3 columns
2) with sorted data as below
orders_qualitys = Order:=xlAscending
then by orders_articless = Order:=xlAscending
then by orders_units = CustomOrder:="Set(s),Pc(s),Pair(s),Dozen(s)"
SECOND PART
I want all the above mentioned data for 2 named ranges in a sheet "Supplier Wise" & sheet "Year Wise" starting from LOOK AT LAST USED ROW FROM FIRST PART THEN LEAVE 5 ROWS EMPTY & COLUMN B & COLUMN D (here column C will remain empty)
1) with removing duplicates keeping in mind 2 columns
2) with sorted data as below
orders_articless = Order:=xlAscending
then by orders_units = CustomOrder:="Set(s),Pc(s),Pair(s),Dozen(s)"
updatequalityarticleunitcodes.xlsm | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Bed Set | CVC Renforce - 90 Gsm | Set(s) | ||
2 | Bed Set | CVC Renforce - 90 Gsm | Set(s) | ||
3 | Bed Set | CVC Renforce - 90 Gsm | Set(s) | ||
4 | Side Pillow | CVC Renforce - 90 Gsm | Pc(s) | ||
5 | Pillow Pair | CVC Renforce - 90 Gsm | Pair(s) | ||
6 | Terry Towel | CTN 400 Gsm PUNCH | Pc(s) | ||
7 | Terry Towel | CTN 400 Gsm PUNCH | Pc(s) | ||
8 | Bed Set | CTN Renforce - 115 Gsm | Set(s) | ||
9 | Pillow Pc | CTN Renforce - 115 Gsm | Pc(s) | ||
10 | Duvet Cover | CTN Renforce - 115 Gsm | Pc(s) | ||
11 | Fitted Sheet | Microfiber Interlock - 135 Gsm | Pc(s) | ||
12 | Bed Set | CVC Renforce - 90 Gsm | Set(s) | ||
13 | Bed Set | CVC Renforce - 90 Gsm | Set(s) | ||
14 | Bed Set | CVC Renforce - 90 Gsm | Set(s) | ||
15 | Bed Set | CTN Renforce - 115 Gsm | Set(s) | ||
16 | Bed Set | CTN Renforce - 115 Gsm | Set(s) | ||
17 | Bed Set | CTN Renforce - 115 Gsm | Set(s) | ||
18 | Pillow Pair | CTN Renforce - 115 Gsm | Pair(s) | ||
19 | Side Pillow | CTN Renforce - 115 Gsm | Pc(s) | ||
20 | Fitted Sheet | Combed Jersey 135 GSM | Pc(s) | ||
21 | Fitted Sheet | CTN Jersey - 140 Gsm | Pc(s) | ||
22 | Fitted Sheet | CTN Jersey - 140 Gsm | Pc(s) | ||
23 | Bed Set | CTN Renforce - 115 Gsm | Set(s) | ||
DATABASE |
updatequalityarticleunitcodes.xlsm | |||||
---|---|---|---|---|---|
B | C | D | |||
11 | Fitted Sheet | Combed Jersey 135 GSM | Pc(s) | ||
12 | Terry Towel | CTN 400 Gsm PUNCH | Pc(s) | ||
13 | Fitted Sheet | CTN Jersey - 140 Gsm | Pc(s) | ||
14 | Bed Set | CTN Renforce - 115 Gsm | Set(s) | ||
15 | Duvet Cover | CTN Renforce - 115 Gsm | Pc(s) | ||
16 | Pillow Pair | CTN Renforce - 115 Gsm | Pair(s) | ||
17 | Pillow Pc | CTN Renforce - 115 Gsm | Pc(s) | ||
18 | Side Pillow | CTN Renforce - 115 Gsm | Pc(s) | ||
19 | Bed Set | CVC Renforce - 90 Gsm | Set(s) | ||
20 | Pillow Pair | CVC Renforce - 90 Gsm | Pair(s) | ||
21 | Side Pillow | CVC Renforce - 90 Gsm | Pc(s) | ||
22 | Fitted Sheet | Microfiber Interlock - 135 Gsm | Pc(s) | ||
23 | |||||
24 | |||||
25 | |||||
26 | |||||
27 | |||||
28 | Bed Set | Set(s) | |||
29 | Duvet Cover | Pc(s) | |||
30 | Fitted Sheet | Pc(s) | |||
31 | Pillow Pair | Pair(s) | |||
32 | Pillow Pc | Pc(s) | |||
33 | Side Pillow | Pc(s) | |||
34 | Terry Towel | Pc(s) | |||
Supplier Wise |
updatequalityarticleunitcodes.xlsm | |||||
---|---|---|---|---|---|
B | C | D | |||
11 | Fitted Sheet | Combed Jersey 135 GSM | Pc(s) | ||
12 | Terry Towel | CTN 400 Gsm PUNCH | Pc(s) | ||
13 | Fitted Sheet | CTN Jersey - 140 Gsm | Pc(s) | ||
14 | Bed Set | CTN Renforce - 115 Gsm | Set(s) | ||
15 | Duvet Cover | CTN Renforce - 115 Gsm | Pc(s) | ||
16 | Pillow Pair | CTN Renforce - 115 Gsm | Pair(s) | ||
17 | Pillow Pc | CTN Renforce - 115 Gsm | Pc(s) | ||
18 | Side Pillow | CTN Renforce - 115 Gsm | Pc(s) | ||
19 | Bed Set | CVC Renforce - 90 Gsm | Set(s) | ||
20 | Pillow Pair | CVC Renforce - 90 Gsm | Pair(s) | ||
21 | Side Pillow | CVC Renforce - 90 Gsm | Pc(s) | ||
22 | Fitted Sheet | Microfiber Interlock - 135 Gsm | Pc(s) | ||
23 | |||||
24 | |||||
25 | |||||
26 | |||||
27 | |||||
28 | Bed Set | Set(s) | |||
29 | Duvet Cover | Pc(s) | |||
30 | Fitted Sheet | Pc(s) | |||
31 | Pillow Pair | Pair(s) | |||
32 | Pillow Pc | Pc(s) | |||
33 | Side Pillow | Pc(s) | |||
34 | Terry Towel | Pc(s) | |||
Year Wise |