Hello Friends,
I need help to Extract DATA from one workbook to another....
Here is the DATA Sample
<tbody>
</tbody>
I need to Extract Data to another workbook with following criterias:
1) Date (Month Wise)
2) Customer
3) Factory
4) Quality
5) Article
6) Dyed or Printed
7) Units
The extracted Data should show a sum of Quantity which matches the above criterias
I would be gratefull if anyone can provide a Solution.
Regards,
Humayun
I need help to Extract DATA from one workbook to another....
Here is the DATA Sample
REF | P.O # | P.O.DATE | Customer | Factory | Article | Quality | Dyed or Printed | Fiber Content | Construction | Size | Quantity | UNIT |
132 | 78118 | 19-Dec-13 | ABC | GA | Bed Sets | CVC Renforce - 90 Gsm | Pigment Printed Rotary | 60% Cotton 40% Polyester | 100D X 22 ctn 76x52 | 1 | 372,472 | Set(s) |
132 | 78186 | 19-Dec-13 | ABC | GA | Bed Sets | CVC Renforce - 90 Gsm | Pigment Printed Rotary | 60% Cotton 40% Polyester | 100D X 22 ctn 76x52 | 2 | 176,976 | Set(s) |
132 | 78581 | 19-Dec-13 | ABC | GA | Bed Sets | CVC Renforce - 90 Gsm | Pigment Printed Rotary | 60% Cotton 40% Polyester | 100D X 22 ctn 76x52 | 1 | 26,088 | Set(s) |
133 | 76424 | 20-Jan-14 | ABC | GA | Bed Sets | CTN Renforce - 115 Gsm | Pigment Printed Rotary | 100% Cotton | 30x30 / 76x62 | 2 | 524,320 | Set(s) |
133 | 76535 | 20-Jan-14 | ABC | GA | Bed Sets | CTN Renforce - 115 Gsm | Pigment Printed Rotary | 100% Cotton | 30x30 / 76x62 | 1 | 192,840 | Set(s) |
133 | 76546 | 20-Jan-14 | CDE | GA | Bed Sets | CTN Renforce - 115 Gsm | Pigment Printed Rotary | 100% Cotton | 30x30 / 76x62 | 2 | 48,360 | Set(s) |
133 | 76627 | 20-Jan-14 | CDE | GA | Pillow Pair | CTN Renforce - 115 Gsm | Pigment Printed Rotary | 100% Cotton | 30x30 / 76x62 | 1 | 372,552 | Pair(s) |
133 | 76634 | 20-Jan-14 | CDE | GA | Side Pillow | CTN Renforce - 115 Gsm | Pigment Printed Rotary | 100% Cotton | 30x30 / 76x62 | 2 | 224,364 | Pc(s) |
146 | 101031 | 25-Mar-14 | CDE | LM | Bed Sets | CVC Renforce - 90 Gsm | Pigment Printed Rotary | 60% Cotton 40% Polyester | 100D X 22 ctn 76x52 | 1 | 107,040 | Set(s) |
146 | 101032 | 25-Mar-14 | CDE | LM | Bed Sets | CVC Renforce - 90 Gsm | Pigment Printed Rotary | 60% Cotton 40% Polyester | 100D X 22 ctn 76x52 | 2 | 115,222 | Set(s) |
146 | 101033 | 25-Mar-14 | CDE | LM | Bed Sets | CVC Renforce - 90 Gsm | Pigment Printed Rotary | 60% Cotton 40% Polyester | 100D X 22 ctn 76x52 | 1 | 31,860 | Set(s) |
147 | 201905 A | 2-Apr-14 | EFG | GA | Bed Sets | CTN Flannel - 140 Gsm | Yarn Dyed | 100% Cotton | 2 | 6,720 | Set(s) | |
147 | 201905 B | 2-Apr-14 | EFG | GA | Pillow Pair | CTN Flannel - 140 Gsm | Yarn Dyed | 100% Cotton | 1 | 1,616 | Pair(s) | |
153 | 102756 | 10-Apr-14 | EFG | GA | Bed Sets | CTN Flannel - 140 Gsm | Yarn Dyed | 100% Cotton | 2 | 65,504 | Set(s) | |
153 | 102757 | 10-Apr-14 | EFG | GA | Bed Sets | CTN Flannel - 140 Gsm | Yarn Dyed | 100% Cotton | 1 | 38,604 | Set(s) | |
153 | 102755 | 10-Apr-14 | EFG | GA | Pillow Pair | CTN Flannel - 140 Gsm | Yarn Dyed | 100% Cotton | 2 | 88,416 | Pair(s) | |
160 | 104685 | 18-Jun-14 | EFG | HT | Fitted Sheet | CVC Jersey - 115 Gsm | Dis/Reactive Dyed | 50/50 Poly / Cotton | 30's PC | 1 | 134,658 | Pc(s) |
160 | 104686 | 18-Jun-14 | ABC | HT | Fitted Sheet | CVC Jersey - 115 Gsm | Dis/Reactive Dyed | 50/50 Poly / Cotton | 30's PC | 2 | 127,962 | Pc(s) |
<tbody>
</tbody>
I need to Extract Data to another workbook with following criterias:
1) Date (Month Wise)
2) Customer
3) Factory
4) Quality
5) Article
6) Dyed or Printed
7) Units
The extracted Data should show a sum of Quantity which matches the above criterias
I would be gratefull if anyone can provide a Solution.
Regards,
Humayun