help Importing data and running macros to edit data in excel 2010
Posted on 2014-11-25
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 want to import this csv into a workbook with at maybe 3 sheets, one to keep all of the historical data that comes in via the csv, one to reference all of the variables that need to be in the sheet and then the main sheet that would basically tell me the results of the last process.
I know the best way to achieve this is through a macro, but the imported data has varying amounts of rows on every import, although the first 8 rows are to be deleted every time, so it would need to include variables to accommodate this.
I would like to create a macro to basically to the following:
import the data
Delete the first 8 results
import the results into the third sheet, moving older data down the sheet. The imported data comes in as rows, and i would like to switch some cells to columns (each set of results is on 8 rows, i want it to be on one row with 8 additional columns).
After that I want to set some variables, if results for A are over variable 1 then mark in red.
Then another set of variables, if results for B are within variable 2 (plus or minus variable 3)
Ultimately, i just want the user to press a button and everything is done, and the results are on screen for them and print out
It has been difficult to explain, i know what is needed and its easy to look at it on paper. Just wanted to get the data into a format thats easy reading
thanks in advance