title: How to populate a cell in one sheet from a cell in the other using excel
body: <p>I am trying to get a row of cell to populate from one sheet in the same workbook to another.  I have sheet1 and sheet2.  They are text fields.  I did the formula =sheet1!A2. It works, but I get a 0 if there is not data in the copied cell (sheet1, A2).  How can I get the zero to be null.</p>