you could simple write a formula like:
=Sheet1!A1

where A1 contains the value you want to carry forward to the other
sheet.

Or am I missing something...?

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=373824