Linked worksheets

  • Thread starter Thread starter Rosemary
  • Start date Start date
R

Rosemary

Hi! I'm learning how to link worksheets for a master
report. When the master report gathers the figures from
the other worksheets, all blank cells show as zeros or one
of the error messages. (It is pulling in numerators,
denominators, and percentages derived from the fraction.)
How can I stop the zeros and error messages from showing
in cells that should remain blank until someone puts a
figure in? This is a yearly report that adds figures each
month.) Thank you.
 
Instead of a simple link, e.g.:

=[LinkedWB1.xls]Sheet1!A1

you can use an IF formula:

=IF([LinkedWB1.xls]Sheet1!A1="","",[LinkedWB1.xls]Sheet1!A1)
 
Back
Top