Hi,
I need some help in planning how I'm going to achieve something, once I know the basic steps i can go away and work on the code.
I have a sheet called "Data" which at the running of a macro imports a raw data regarding disk space on 200 servers. Another sheet "Report" using multiple formulas(the raw data is horribly formatted) then looks at the relevant data in the "data" sheet and turns this into a manageable report.
What i want to do is each time I import a new set of raw data somehow track changes to show the biggest increases and decrease (basically keep a history).
Any ideas on how I would do this.
I need some help in planning how I'm going to achieve something, once I know the basic steps i can go away and work on the code.
I have a sheet called "Data" which at the running of a macro imports a raw data regarding disk space on 200 servers. Another sheet "Report" using multiple formulas(the raw data is horribly formatted) then looks at the relevant data in the "data" sheet and turns this into a manageable report.
What i want to do is each time I import a new set of raw data somehow track changes to show the biggest increases and decrease (basically keep a history).
Any ideas on how I would do this.