mardi 30 juin 2015

VBA loop to find entries and copy items

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