The attached (file initial) solution is the solution to a previous question (must see link below for background info).
The expert working on my previous stage has now got to a stage whereby the resulting work sheet displays the desired modification for the source data (2.txt) that was provided.
As I have explained in the previous question. I am looking for the macro to work universally on all of my future stock reports. The reports will always be in the same format and layout but the data will change e.g. monthly data, free stock and new products (codes) added. I have attached 3 separate and different stock reports (named; 1,2,3). If the macro works successfully on all of these 3 reports we know we must be close to a solution. A good way to test a successful result is if the overall totals at the bottom of the original source data files match the totals on the parsed (modified) sheet. Free stock total MUST also match
Once you have done sufficient enough testing to ensure the macro works universally I would like a button called 'parse and modify stock report' to be added to my master utility sheet (attached). When clicked all I would have to do is select the relevant stock txt. file and click ok. The macro will then run automatically.
Any questions just ask.