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)