|Subject:||how to highlight changes in my data from one block of cells to another block of cells?|
|Posted by:||LunaMoon (lunamoonmo…@gmail.com)|
|Date:||Sun, 27 Jul 2008|
Let's say I am collecting data for experiments.
For each experiments, there are a bunch of data I have to collect$B!'(B
Every time I change a few settings and hit the run button, the
experiment will run and the results will be recorded.
How do I efficiently organize the collected data?
Currently, I just copy down a whole bunch of numbers to a 100 x 100
cells in a new sheet.
Every time I run the experiment, the results are copied to the 100x100
cells following the previously recorded many 100x100 cells.
Is this the best way to do such things? I need some productivity
Then the next step is to visualize the changes, for example, changing
one parameter will lead to what changes in results, this is the key
question I am asking myself.
I hope to be able to draw a line to highlight the changes I've made
from one 100x100 data block to the next 100x100 data block. This is
much like the "trace" feature in formula auditing...
How do I do that using EXCEL/VBA? Is this the best way to visualize
the results of experiments?