I am trying to figure out how to create a loop that will check the values of E until column E is empty. If there is a 1, I want to select the adjacent information in columns B & C, and copy the selection.
B C E
Item Cases to send Helper Column
22935 270 0 24504 1080 0 40070 189 1 41883 360 0 41884 312 1 AX001 156 1 AX003 396 1 AX024 1320 1 AX025 198 1 AX032 594 1 AX033 264 1 AX042 297 0 AX081 1224 1 AX102 210 1 AX202 1260 0 AX310 840 1 AX312 910 1 AX508 840 1 AX833 576 0 B0052 144 1 H1012 165 1 K0120 243 1 MP804 594 0 OG101 660 1 W2100 81 0 W3628 2331 0
Aucun commentaire:
Enregistrer un commentaire