I have one solution that reads the text file
in the exact format you have it: 9 rows of data
in each set, followed by sets of data with
nine rows each, and all rows except the country/zip
row are delimited by one occurrence of " : "
This may work for you if your data is consistent
with the format you provided. My attachment
includes two sets of records for testing purposes.
Copy both the Excel file and text file to the same folder
to try it out. Open up Module1 and run the Test_GetData
function to bring your data into Sheet1.
Good luck with your project.
Bookmarks