Linking Master Workbook & subordinate workbook

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top