Linking Master Workbook & subordinate workbook
 

I am linking several workbooks, cell for cell, into a masterwork. However,
when I link a blank cell into the master workbook, a zero is put into the
master cell. Is there a way to keep the link, in case information is later
entered into the subordinate workbook, but no value is entered to the master?
Thanks for your help.
Johnnie

Linking Master Workbook & subordinate workbook
 

Lucky, in the master workbook, enclose the link in an if statement, such as:
if(linked cell="","",linked cell). The master workbook cell will appear
blank until something is entered into the linked cell. HTH
--
Sincerely, Michael Colvin


"Lucky_guy2000" wrote:

I am linking several workbooks, cell for cell, into a masterwork. However,
when I link a blank cell into the master workbook, a zero is put into the
master cell. Is there a way to keep the link, in case information is later
entered into the subordinate workbook, but no value is entered to the master?
Thanks for your help.
Johnnie