I have recorded the below Macro (basically splits out a long text string into something readable, with headers etc)
What I would like is to be able to amend this, so that instead of copying and pasting the data from the source file into an excel template, I can just open the .xlt and be prompted for the file name/file path of the file with the data in and it be automatically formatted as below.
Also, it would be good if once formatted, it was saved as .xls in the same location as the source file.
Not sure if this is possible, probably is, but beyond my level of knowledge.
There a quite a few of these macros, so is reasonably time consuming copying and pasting all the relevant data.
Please Login or Register to view this content.