hi need help for a look that do
Run a loop cycle that searches for the word "Special" in column A1 (the cell a1 contains different words inside)
If true looking if b2 = "Quantity" deletes b1 row)
in red is what i need to be deleted
Thanks for help
A B
<colgroup><col><col></colgroup><tbody>
</tbody>
Run a loop cycle that searches for the word "Special" in column A1 (the cell a1 contains different words inside)
If true looking if b2 = "Quantity" deletes b1 row)
in red is what i need to be deleted
Thanks for help
A B
Special 175377.2 QG #LDP 2443 #AVP 4748 | Quantity |
ECEPI443 | 1 |
EPILZ750103 | 1 |
ESI6AV21232DB030AX0 | 1 |
ESI6ES72151AG400XB0 | 1 |
ESI6ES72231BL320XB0 | 2 |
ESI6ES79548LC020AA0 | 1 |
EDATTHQQS00 | 1 |
Special 175427 QG #LDP 2442 #AVP 4726 | Quantity |
ECEBGS8625 | 1 |
ECEOCM50100BB07 | 1 |
EPILZ750103 | 1 |
ESI3LD22130TK51 | 1 |
ESI6ES72151AG400XB0 | 1 |
ESI6ES72231BL320XB0 | 1 |
ESI6ES79548LC020AA0 | 1 |
ESI6AV21232DB030AX0 | 1 |
ETMXB4BVB6 | 1 |
Special 175364 BD #LDP 2441 #AVP 4740 | Quantity |
ETMA9F79102 | 1 |
Special 175364 QG #LDP 2439 #AVP 4751 | Quantity |
Special 175346 QG #LDP 2438 #AVP 4750 | Quantity |
ECEOCM50100BB07 | 1 |
EPILZ750103 | 1 |
ESI3LD22130TK51 | 1 |
ESI6ES72151AG400XB0 | 1 |
ESI6ES72231BL320XB0 | 1 |
ESI6ES79548LC020AA0 | 1 |
ESI6AV21232DB030AX0 | 1 |
ETMXB4BVB6 | 1 |
Special 175364 BD #LDP 2441 #AVP 4740 | Quantity |
Special 175364 QG #LDP 2439 #AVP 4751 | Quantity |
Special 175346 QG #LDP 2438 #AVP 4750 | Quantity |
GIA IN ORDINE DA UFFICIO TECNICO - NON SERVE ORDINARE!!! | Quantity |
<colgroup><col><col></colgroup><tbody>
</tbody>