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.

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

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

On Sep 22, 2:44*pm, Deb <Deb @discussions.microsoft.com wrote:
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.