remove fill in text from a cell from an unpopulated fill-in cell

[Deb]

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.

 

[Pete_UK]

You could have a formula like this in A1 of sheet 2:

=IF(Sheet1!A1="","",Sheet1!A1)

so that you get blanks if there is a blank in sheet1.

Alternatively, you can use conditional formatting to set the
foreground colour to white if the cell content is zero, so this will
appear as a blank cell if you use a white background.

Hope this helps.

Pete