View Single Post
  #1   Report Post  
KimberlyC
 
Posts: n/a
Default Refrencing another cell in a worksheet that "could" exist

Hi

I'm not sure if this is possible....

I have a worksheet called "Adjust".
In cell C15 of the Adjust worksheet, I would like to reference the total in
cell Q30 of another worksheet called "Additons".

I know how to do this ...but the problem..is...
The "Additions" worksheet may not always be there... it's an optional
worksheet that can be added if needed (via macros in an addin file).
Is there a formula that I can enter into cell C15 of the "Ajust" worksheet
that will show zero if the "Additons" worksheet does not exist ....and if
the worksheet does exists, then have the formula reference the total in cell
Q30 fo the "Additons" worksheet??

Thanks in advance for your help

Kimberly