Createing a self-sustaining column?

[Mike]

Here is what I want to do... I need to build a database
of a few 100 inputs. But all I want to do is put in one
input. For instance, each row has five columns. I put in
the first column and the other four can be calculating
using just the first column. For the second row I want it
to take the value of the last column of the row prior. So
on so on. So row 60 column 1 would take the value of row
59 column 5...

Is there a way to set it up so that all I need to do is
put in the first value, row 1 column 1. And excel will
calculate all of the values straight through?

For instance my columns are like this...
C1 C2 C3 C4
5 .5 2.5 7.5
7.5 .5 3.75 11.25
11.25 .5 .........

Thanks

 

[Bob Phillips]

Assuming A1 to E1000

In A2, add =IF(E1<>"",E1,"")
Copy B1:E1 to B2:E2
Copy A2:E2 down to A1000:E1000

--

HTH

RP
(remove nothere from the email address if mailing direct)