referring entire page

[torpido]

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.

[Otto Moehrbach]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[torpido]

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]

anybody please