| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| start page numbering after table of contents | Excel Discussion (Misc queries) | |||
| How do you print Exel gridlines on the entire page ? | Excel Discussion (Misc queries) | |||
| Copy page format into an entire workbook | Excel Worksheet Functions | |||
| Auto page numbering for several worksheets | Excel Worksheet Functions | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
Linear Mode
