In cell BL20 type =A20.
Now, anything entered in A20 will appear in BL20.
--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile:
http://www.excelforum.com/member.php...o&userid=34730
View this thread:
http://www.excelforum.com/showthread...hreadid=556685