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
Bookmarks