Creating a data series using another worksheet?
Hi all, does anyone know how to use the formula sequence of one
worksheet to generate a data series in another?
Worksheet #1 has a rather complex sequence of generating an output X
from inputs A, B and C.
Worksheet #2 has a long list of possible values for A in col.A. With B
and C remaining fixed in Worksheet #1, how do I use Worksheet #1 to
automatically generate corresponding X values, and have Excel post them
in Worksheet #2's col. B alongside the corresponding A values already
there?
Objective is to, based on the flow of Worksheet #1, produce a graph of
X for varying values of A.
Thanks,
Bob
|