I have a text file to convert to Excel. This file is special because there are multiple lines per record.
Ex: 1st record 1st line in file is Plate Number: AZAB34596
2nd line of same record # 149885665 date: 07/05/13 type: License Plate
3rd line same record Time: 12:49A location: 1738 Welton St
The ticket amount is not required. All the other extraneous lanaguage is not required.
Any way to do this with VBA?