I have had some fantastic input with the macros which help me automate some of my audit reporting by heavily formatting the imported data into something a bit more useful.
I am having a bit of a problem with one of the macros. Macro 1 - FormatImportText - brings the raw data and formats it into 5 columns rather than spread out over 6.
Macro 2 - FormatText - moves the columns around and formats the data further.
In the attached example, the macro is only formatting 5 of the rows rather than 12. I have been staring at it and playing around with it but I have had no luck so far.
Would someone please take a look at the macros and see what I am failing to see?
Any help you could give me would be greatly appreciated.