You can make it look empty with a formula like:

=if(sheet1!a1="","",sheet1!a1)



Lambros wrote:

Now this should be easy. I have a workbook with 2 worksheets. Lets say when
A1 is filled in on worksheet 1 I want the same information to display in A1
on worksheet 2. I used a the formula on worksheet 2 in cell A1:
=worksheet1!A1

why does that cell in worksheet 2 display a 0 when there is not yet
information in the cell it's copying from in worksheet 1? How do I get it to
just be blank until information is put into that A1 on worksheet1?

--

Dave Peterson