N
Nathan
How do I prevent Zero's from appearing in empty cells that are paste linked? The check box "Skip Blanks" is not available when paste link is used.
Example:
There are 2 work books: Master and Received. Master has data that is to appear in Received and update in Received when Master is updated. The data in Master is not contiguous (there are empty cells). These empty cells may have information entered into them on a later date that must update in Received. When one looks at Received, the data that appears has numerical importance to the reader. If the reader sees no data in a cell that cell is not considered, but if a zero appears; that has numerical significance to the reader. How is this accomplished?
Thank you,
Nathan
Example:
There are 2 work books: Master and Received. Master has data that is to appear in Received and update in Received when Master is updated. The data in Master is not contiguous (there are empty cells). These empty cells may have information entered into them on a later date that must update in Received. When one looks at Received, the data that appears has numerical importance to the reader. If the reader sees no data in a cell that cell is not considered, but if a zero appears; that has numerical significance to the reader. How is this accomplished?
Thank you,
Nathan