Separator to identify similar rows and code to add it

[sncb]

Hi All,

I have a macro that cuts data from one tab and pastes it in this tab. But if you see the PO numbers for A3, A4 and A5 they all have the same PO numbers and I wanted to separate them and was able to separate A4 ad A5 but concatenating them (Col C).

Excel Workbook
	A	B	C	D	E	F	G
1	PO Type	PO Number	Type/Number	Order date	Keep	Salesperson	*
2	GB	1650	GB1650	16-Feb	N	Brad	*
3	GB	1500	GB1500	23-Feb	N	Michela	*
4	GB	1500	GB1500	23-Feb	N	Michela	*
5	LP	1500	LP1500	23-Feb	N	Michela	*
6	MN	2500	MN2500	8-Mar	N	Jasmine	*
7	MN	3000	MN3000	12-Mar	N	Derek	*
Sheet1

But the problem I face is that sometime the PO number and the PO codes are the same (A3, A4) and I need to add a separator to separate them.

Any suggestions on what could a separator be and also the code to add another column(or take next free column) and add the separator.

Thanks in advance

 

[sncb]

Anyone? Bump!!