I have an extract from a third party piece of software that dumps its data after a process has ran to a csv file.
I now have a macro that imports the data into my results book and cleans it up, this next process would have to be part of this macro in order for the correct results to turn up on the results page after import.
What I need now is a macro to move the data from my import sheet (called Historical data) to my results sheet, upon moving these in to the sheet, I need the macro to put my data into column format rather than in row format, inserting all new data in the top cell. During this process, I will need a time and a date stamp adding to the imported row. I have created a table to illustrate which columns are required from the Historical data sheet.
Ideally I would like the import of the csv macro and this macro to be a single click button on the results sheet.
Once the data is in this new table, conditional formatting will need to be applied to highlight a pass or fail according to variables, all set up on the variables page