I'm sure this is simple but I can't get it to work.
I have a series of numbers in cols A and E as below
A B C D E F
1028586 B Current E 1000111000001101 1028586
1008928 B Discont 1000511000001105 1008928
1008929 B Discont 1000511000001105 1008928
1008930 B Discont E 1000511000001105 1008928
1029734 B Discont E 1000611000001109 1029734
1000712 B Current E 1000711000001100 1000712
1010520 B Discont E 1000811000001108 1010520
1013190 G Discont E 1001011000001106 1013190
1003871 B Discont 1001211000001101 1003871
1011226 B Discont E 1001211000001101 1003871
1018719 G Discont 1001411000001102 1018719
1001709 B Discont 1001411000001102 1018719
1018709 B Discont 1001411000001102 1018719
1020084 B Discont E 1001411000001102 1018719
What I want to do using VBA is to put the number in col A into col F, but if the number in col E is duplicated, then the number drawn from col A should also be duplicated as per the above example.
Overall there are 30,000+ rows in use!!
I would be grateful for any help you can offer.
Bookmarks