Hello,
I have a worksheet that is a "total" sheet for 2 other worksheets.

I put the formula = then reference the other worksheet specific cell. I
will not fill in the 2nd sheet for 2 weeks. On the total sheet is shows as
#REF!.

How can I hide that #REF! until the 2nd sheet is filled in?

Thanks
--
Kim