Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Start & End of the data series | Excel Worksheet Functions | |||
Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
How do I reference data from one worksheet to another using combob | New Users to Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |