I think you've got 2 options. If there aren't other things in your
spreadsheet, you could redo the formula as I outlined. I'm guessing,
however, from the scattered nature of the cells that you probably do have
other information that might get in the way.

The first option would be to take the intermediate calculations to another
tab and then bring the answers back to the original tab. You'd have to
change some of the references to work with columns and such. So probably
your best bet would be to redo the original calculation on the other tab, and
then copy it down.

The other option would be to write some VBA code. This probably isn't too
hard unless you've never done it before. In this way you'd move the
intermediate results off the spreadsheet, and just loop through the rows in
your code.

I won't be available too much longer this evening so if either option sounds
doable I'm sorry but I won't be able to help. If you don't have an immediate
deadline, I could help sometime tomorrow or tomorrow evening. Alternatively
someone else may jump in tonight and be able to help.

Lots of luck - I hope you can get this to work.

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