Absolutely it's possible. IMO a spreadsheet would be a pretty useless
piece of software if I couldn't somehow link the value in A2 to the
value entered in A1. From the simplest formula A2=A1 which makes A2
simply a reflection of the value in A1 to complex engineering formula
to text functions to lookup functions and on and on.

It really isn't a question of, "is it possible." Rather you need to
determine what the relationship between the value in A2 and the data
entered in A1 and make the spreadsheet do it.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=374144