Insert row macro works but small tweak needed

[makinmomb]

This is a macro , does the job right , inserts a line at every new stock code

Though it not recognizes product colour as follows

CL0091BR36
CL0091BR37
CL0091BR38
CL0091BR39
CL0091BR40
CL0091C36
CL0091C37
CL0091C38
CL0091C39
CL0091C40
CL0091C41

CL0413AG36
CL0413AG37
CL0413AG38
CL0413AG39
CL0413AG40
CL0413BZ36
CL0413BZ37
CL0413BZ38
CL0413BZ39
CL0413BZ40
CL0413BZ41

[makinmomb]

If the formula on the macro is just little tweaked it the above two code types will looks as follows

CL0091BR36
CL0091BR37
CL0091BR38
CL0091BR39
CL0091BR40

CL0091C36
CL0091C37
CL0091C38
CL0091C39
CL0091C40
CL0091C41

CL0413AG36
CL0413AG37
CL0413AG38
CL0413AG39
CL0413AG40

CL0413BZ36
CL0413BZ37
CL0413BZ38
CL0413BZ39
CL0413BZ40
CL0413BZ41

[xlbiznes]

this will do the job :

Please Login or Register  to view this content.

[makinmomb]

Thanks , patience paid

Had work at around 10,000 rows