Pull Info from a Data Log and Organize into Separate Columns?

Good morning Excel Forum!

I've been trying to find a way to streamline pulling specific sections of text from an program log and separating it into columns in a spreadsheet. The log is basically a daily "Audit Log" that tracks all data being imported into a program:

Importing File: D:\CustData\REPORTNAME.txt, modified at 3/29/2017 10:35:37 PM
Executing Custom Process (Ignore User Ignored Pages)
End Executing Custom Process
Executing Custom Process (Set Transaction Date)
End Executing Custom Process
Start Processing Teller Records (Import ID: PCTR12345)
Total Records: 123
Successfully Imported: 123
Excluded: 0
End Processing Teller Records
Total Report Lines: 345258
Warning: The Record\Line Ratio (0%) is below the minimum (50%) threshold, see Report File Detail report for more details.
Archiving file: D:\CustData\REPORTNAME.txt
End Importing File

The log is exported into Excel spreadsheet format, from which I manually copy/paste certain parts (see Bolded above) of the log into another spreadsheet with columns separating the data:

Date Imported	Imported File Name	File Creation Time	Import ID	Records Imported	Records Excluded
03/29/17	D:\CustData\REPORTNAME.txt	modified at 3/29/2017 10:35:37 PM	PCTR12345	123	0

To clarify, I am pulling information from an Excel spreadsheet and copy/pasting it into another Excel spreadsheet. Is there a way to automate/streamline this process besides manually copy/pasting the information or is copy/pasting the information the easier route? I do this monthly so you can imagine having to sort and copy/paste 30+ days of the same type of data can get pretty tedious and is pretty much time wasting.

Post a workbook with the before copied data, and the after pasted data
(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

Attached are the spreadsheets I use. Rawdata is the Log that is exported from the program I use, and Final is the organized columns that I paste the selected data into.

FYI - the log was condensed to just this particular section as there is sensitive information that I had to cut out. The position/lines of the data is always changing, so what you see on the uploaded spreadsheet isn't necessarily as the same spot through all the different logs.

I don't know how many records are actually imported in the "raw" file or what the actual sheet names are so you will have to modify this as necessary:
It is intended to run from the "final" workbook.

Please Login or Register  to view this content.

I thought that might be the casse. Please post a more representative workbook (raw/csv).