View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
APElizondo APElizondo is offline
external usenet poster
 
Posts: 1
Default 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.