View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deb[_3_] Deb[_3_] is offline
external usenet poster
 
Posts: 1
Default remove fill in text from a cell from an unpopulated fill-in cell

I used the = function in the 2nd and 3rd sheets to copy data from the 1st
sheet. I copied the formula into the the existing 30 rows on the 2nd and 3rd
sheets. There is no data entered on the 1st sheet thus returning placemarks
in the 2nd & 3rd sheets where I've copied the formula. How can I hide these
placemarks until data is entered in the 1st sheet.