referring entire page
 

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

referring entire page
 

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

referring entire page
 

that formula dosent work, are u sure its correct, also its kinda hard to
do that cell by cell.
basicly i want to copy a page(which i know how to) and referre it to
the orginal so when i type something in it it copies to the duplicated
page, without have '0' on blank cell's


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

referring entire page
 

anybody please


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