Hi,
I am very confident on handling this writing of generic macro using VBA to convert various terminal formats to standard format. If possible, please share the variation of the formats to understand the degree of deviation.
Just to introduce myself, I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc.
I would be happy to answer any queries that you may have.
Looking forward to hearing from you.
Thanks & Regards
FineCoder