Hi again.
I've got another question for you all.
In Column A there are Part Codes separated by a blank line. Column B are the Vendor codes which are pasted in each time
Is it possible after the codes are pasted into column B, extra rows are added as below and the Part Code 1 codes are duplicated. Then when codes are added for Part code B1, the same happens again
Hope this makes sense.
Thanks for looking,
Graham
I've got another question for you all.
In Column A there are Part Codes separated by a blank line. Column B are the Vendor codes which are pasted in each time
Column A | Column B |
Part Code1 | Vendor Codes |
A1 | CCC |
DDD | |
B1 | EEE |
FFF | |
C1 |
Is it possible after the codes are pasted into column B, extra rows are added as below and the Part Code 1 codes are duplicated. Then when codes are added for Part code B1, the same happens again
Column A | Column B |
Part Code1 | Vendor Codes |
A1 | CCC |
A1 | DDD |
A1 | EEE |
A1 | FFF |
B1 | |
C1 |
Hope this makes sense.
Thanks for looking,
Graham