How can I have a value from one cell transferred to an adjacent cell when a
neighbouring cell is empty.
Example: an amount invoiced to client is copied to another cell to be added
where there is no invoice number entered.
Purpose: values are entered when time sheets are completed. This provides a
running balance of time not billed until an invoice number is entered,then
the value opposite the invoice number is automatically omitted from the list.