The attached file name stockuseage.txt is the raw data for a stock usage file for all of our current supplier stock.
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.
The attached sheet (manual example) shows the data which needs to be kept between the range A414:473. The macro would have to cover the whole data range.
note the product descriptions often push onto two lines. These need to be consolidate onto the one line whilst keeping the relevant data aligned.
Also note each page is assigned to a different product group. These groups need to be pulled from above the data and aligned next to the relevant product code (see manual example).
Any questions just ask