I was wondering if there is a simple way to make one cell takes multiple
inputs, essentially turning a cell into a placeholder.

Example:

Sheet1!A2=Sheet1!A3+5

Sheet1!A3 will take arbitrary value from Sheet2!A3 or Sheet3!A3, and
return the answer to Sheet2!A4 and Sheet3!A4, respectively.

If Sheet2!A3=2, then Sheet2!A4=Sheet1!A2=7
If Sheet3!A3=4, then Sheet3!A4=Sheet1!A2=9

Thank You.

csw


--
csw78
------------------------------------------------------------------------
csw78's Profile: http://www.excelforum.com/member.php...o&userid=23008
View this thread: http://www.excelforum.com/showthread...hreadid=374134