The button "Update Stock Codes" is used to run a macro that automatically fully parses product code information from its original form into a usable data set.
I am trying to parse the sheet attached source data sheet "codes update" but have noticed the macro is returning some errors. Specifically where "'s are used within the original data it is causing the information to shift into the wrong cell.
I have highlighted (yellow) some of these errors on the results sheet to give an example.
I'm pretty sure the coding of the macro will need to be altered to prevent these phase shifts form happening?