Attached are three original text file documents.
They display stock usage for products during a four month period.
I basically need a macro to split and modify the data from the original text for into relevant columns so it can be worked with in excel.
This is a macro that will be run repeatedly for different supplier stock files. For this reason I have attached three original text files. If the macro works successfully for all three we can assume it works correctly.
I have highlighted the data which needs to be kept on the attached sheet (bosch example). Information not relating to these parameters can be removed, e.g. "PRODUCT GROUP BOSCH", THS DIRECTSTOCK USAGE REPORT by Product Group Produced On: 20/ 8/14 Page 3"
note the product descriptions often push onto two lines. These need to be consolidate onto the one line whilst keeping the relevant data aligned.
Any questions just ask