How do I set one cell to equal another if its contents are empty?
I have an insert for my work menu and everyday something changes on it. It
is a small square of information but I have duplicated it to print four on
the same page. I have assigned each cell to equal the original one so that
everytime I change the information in that cell it will automatically
duplicate it in the three other cells. My problem is that everytime I want
to clear a cell-the duplicate cells show a 0 and I want it to stay empty. If
I clear that cell the equal to function erases.
|