For example:

Instead of sheet1 and sheet2, assume the sheets are named Formsheet and
Summarysheet.

Cell A1 of Formsheet has the input data, and you want cell A1 of
Summarysheet to have the same data in it.

Type this formula into cell A1 of Summarysheet:

=+Formsheet!A1


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=487454