Creating a data series using another worksheet?

B

Bob

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
 
Top