| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking Information in Sheets based on its content
I am trying to link information in several worksheets so that if I change the
information on the first one, then the others would be updated. My first worksheet includes various phone numbers (home & mobile). If there is a phone number available, it links properly - however, if they do not have a number, then the value comes up as "0". I would rather have the entry blank. What formula would I use? Currently, it is set up as 'Worksheet1'!B2. Would it be an "IF/OR" function? Thank you for your assistance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide/Delete entire rows based in the content of one cell | Excel Discussion (Misc queries) | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| Linking WorkBooks Based on Data Entered In One of Them | Excel Discussion (Misc queries) | |||
| hot to access deleted information in excel sheets | Excel Discussion (Misc queries) | |||
| Can you conditional format based on information in cell comments? | Excel Worksheet Functions | |||
Threaded Mode
