Thank you so much for your help. One follow-up question.

When I use the function given, I do not get the "0" on the
linked sheet, however if I go back to the original and put
something in that cell is does not transfer over. Is there
an And/Or function that will correct this problem?

Check the calculation mode

Tools Options Calculation tab Check "Automatic" OK

And... you should stay in your original thread ..

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
----
"Stacy Taylor" wrote in message
...
Thank you so much for your help. One follow-up question.

When I use the function given, I do not get the "0" on the
linked sheet, however if I go back to the original and put
something in that cell is does not transfer over. Is there
an And/Or function that will correct this problem?