how to highlight changes in my data from one block of cells to another block of cells?

Giganews Newsgroups
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

Hi all,

Let's say I am collecting data for experiments.

For each experiments, there are a bunch of data I have to collect・3校

1. Parameters;
2. Variables;
3. Results.

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
advice...

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?

Thanks!

Replies