Hello Group,
I'm attempting to automatically format a report that has several parts and
break it down to what I need.
The report comes in plain text and has three parts that all in with the
phrase total : in the last part of that section. I'd like to see about
having it break down each
I think I'd skip the part about reading the raw data into the Paste Sheet.
Instead, I'd read from the text file and place it in the appropriate sheet.
A simple method would be like this:
Option Explicit
Sub ReadData()
Dim TDataFile, TextLine, TxtArray
Dim Sht, oRow, inx
TDataFile