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>
