Help with Worksheet change macro

[Cruiser69]

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

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

 

[Cruiser69]

Thank you very much for this Scott

Regards,

Graham