| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Links to another workbook returning 0
I have four managers who fill in identical sheets, the boss wants one
workbook with links to each managers sheet, so he can check team progress. The trouble is if there is nothing in the source cell, the link returns 0 which SOMETIMES is valid! What I want is if the source cell is empty to get nothing and only get 0 if that is what is in the source cell. On the source sheet I use conditional formatting to highlight an empty cell if a (logically) related cell has a value in it. (the cells are Job No & Shift - 0 is a valid shift value) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning contents of a cell in another sheet in same workbook | Excel Discussion (Misc queries) | |||
| Searching in another workbook for a string and returning with the contents of the cell next to it. | Excel Worksheet Functions | |||
| My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
| Workbook Links | Excel Worksheet Functions | |||
| UDF not returning proper value - circular reference/multi workbook | Setting up and Configuration of Excel | |||
Threaded Mode
