I am importing text reports from an AS400 into excel.
I have the import code down and have cleaned up the data so only relevant things remain.
I am not that great with VBA and am stuck on appending the header detail to the individual records.
Attached is what I have thus far in EU_IPI_FILE.xlsm
Source Report is PRT014G5511212.txt
the Only_Relevant_Data tab is where I am currently at.
the append tab is what I need to get to.
Any help is much appreciated.