ExcelBanter - linking to other workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - linking to other workbooks (https://www.excelbanter.com/excel-worksheet-functions/147320-linking-other-workbooks.html)

Bouket

linking to other workbooks

I am linking cells from one worksheet to another. When there is nothing
entered yet in the worksheet that I want the into to carry over from, it
is inserting a 0 in the cell (but shows my formula in the top fx box).
Do you know how to get rid of that 0 so the cell is completely blank
until the info is entered on the worksheet it is linked to?

Gord Dibben

linking to other workbooks

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

Will make the cell look blank.

Gord Dibben MS Excel MVP

On Wed, 20 Jun 2007 13:05:38 -0700, Bouket
wrote:

I am linking cells from one worksheet to another. When there is nothing
entered yet in the worksheet that I want the into to carry over from, it
is inserting a 0 in the cell (but shows my formula in the top fx box).
Do you know how to get rid of that 0 so the cell is completely blank
until the info is entered on the worksheet it is linked to?

All times are GMT +1. The time now is 09:51 AM.