referring entire page

T

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.
 
O

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
 
T

torpido

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