You can do Edit - Move or Copy Sheet, select to make a copy, and you get the
whole sheet.
The general formula for copying a cell without getting the "0" if the
referenced cell is blank is:
If(A1="","",A1)
HTH Otto
"torpido" wrote in
message ...

hi guys
i want to know if there is anyway that a page can be referred to
another, like when u say a1=a2 i want to do sheet1=sheet2.
i can do that manualy but then a empty cell will be shown as "0" which
i dont want.
if there is no way then ist possible to referre a cell to another
wihout having 0 on blank referral.


--
torpido
------------------------------------------------------------------------
torpido's Profile:
http://www.excelforum.com/member.php...o&userid=26482
View this thread: http://www.excelforum.com/showthread...hreadid=535207