referring entire page

  • Thread starter Thread starter torpido
  • Start date Start date
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.
 
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
 
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'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Message box called if 1 of 3 options is entered. 4
Excel formula, sum the value cell and if empty cell left blank 0
Reference to cell with external spreadsheet 1
Excel Msgbox runing beyond posted cell range. 1
Countif contains a word in a reference cell 3
Excel Need assistance with modifying a Duplicate declaration. 13
specific data 1
referring to a total in a cell that varies each month 5

Back
Top