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?