I work in the aviation industry compiling data submitted by the US major airline carriers. Our system is a legacy system and its functionality is limited when it comes to output.
The system will output the data into a .CSV file. Each month, I need to copy the data into a table with headings, name of carrier, year, etc. It is a very time consuming processes as we have 900-1000 carriers. Could you create a macro that automatically performs these steps? The data needs to appear in a table format structure for our external and internal customers.
I have attached my spreadsheet. The data on "Data in CSV format..." is the output data. The tab of "Data in XLS Format..." is what I am trying to accomplish. I have placed notes into this tab explaining how the data should be displayed. Please let me know what you come up with! I really appreciate the hard work the Experts do to make my job easier!
Thank you. Please advise with questions.