Linking Master Workbook & subordinate workbook

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Similar Threads

Merge Multiple workbook sheets into one workbook 0
Linking cell to different workbook 2
Mulitple Workbooks and Ignoring Blank Cells 5
Stop linked cells from changing when insert new row? 1
Linking to other workbooks question 4
AutoUpdate links / Workbooks saved by date??? 2
summarizing data from various workbooks 3
How to create absolue path link to another workbook (Excel 2003) 1

Back
Top