G'day Wheelz,
I had a play in excel to try and work it out, you have a circular
reference, which you prob already knew, however what i suggest is that
you have a couple of tables. eg if variables are " blue cells " then it
works out " black cells " if a black cell has to be a variable then set
up another table so that when value is put in there then it gives you a
value for the missing info in blue cells.
Dunno if you have tried this or if it helps, other than that if you
like send me an email with a detailed explanation of what each varible
is eg " Speed ( Vc ) m/min is taht velocity in metres per minute,
excuse my dumbness. I will try and help any way as i believe every
circular reference has a work around.
Cheers Daz
--
aussiedaz
------------------------------------------------------------------------
aussiedaz's Profile:
http://www.excelforum.com/member.php...o&userid=37270
View this thread:
http://www.excelforum.com/showthread...hreadid=569785