View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Bob is offline
external usenet poster
 
Posts: 1
Default 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