formula - table - cells

R

ribit

hello,

bit difficult to explain... but here it goes. I have a table of value
'x' and 'y'. At the moment I must enter all these values manually in
turn into 2 cells which turn calculate 'a' and 'b' values (which I must
then type in next to the appropriate 'x' and 'y' values). Is there an
automated way of doing this (posibly using VB)? Please help...

Regards

Mat
 
S

steveB

Mat,

With Excel, there is always a way (almost always). But we need more
information. How about putting a simple example in your next reply...
 
R

ribit

hi SteveB,

I have an example to explain a bit more cleary what I meant in my las
message. The equation I use in my real problem is much more comple
(equations getting results from other 'equations results' etc...) bu
it show briefly what i am trying to do...

Is it of any help?

thanks

Regards

Ma

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56092
 
Top