You are right in your assumptions, this is the 2nd time I've used excel.
When I try to copy in excel it changes the references relative to where it is
copied - I don't know how to make it keep absolutes. So I copied the
results to a text editor as I referenced each input manually. Then copied
all the results from the text file back to excel. This worked for the
project tonight. I really appreciate your input. Sounds like a little VBA
code would do this next time. Thanks again Art.

"Art" wrote:

Oh -- one more thing. There is the scenario manager. I've rarely used it,
but perhaps that could help. I don't think you'll get it to list your
results down the rows of C-F, but it may be better than nothing.

Art

"Chad Sellers" wrote:

It would be difficult to try this. I have the input number at A2. Two
numbers at A5 and A^ are used to get an area and perimeter in A7 and A8. I
multiply these by the input in A2 and save at G7 and G8. Then the quadratic
result is placed at G12 and G13. These are rounded so the results I want are
at A12 and A13 with an error also wanted calculated and placed at A15 and
E15. What I would like to do is run a list of numbers placed at B19-48 as
if they resided at A2 and save the results from A12, A13, A15 and E15 to C-F
: 19-48 respectively..

"Art" wrote:

Can you just copy your formula? For example, let's suppose that the "one
number" is in cell C1. Suppose the other numbers are in A1 - A4. Finally
assume that your formula is in D1-G1.

Now, run down column C with the rest of the numbers. Then copy the formula
in D1-G1 down, next to the values in C. You'll need absolute references for
the values in A1-A4.


Art
"Chad Sellers" wrote:

I made an excel file to generate results from one number as the input a
couple of other fixed numbers to reference against and a couple of algebra
and quadratic equations to generate the desired answers. Can I make a list
of numbers in my excel file and have excel run through the equations already
set up and generate a list of results? If not, how do I make a file that
will step through a list of numbers, run excel on each and save the results
for each? Thank you, Chad Sellers