That worked perfectly. Thank you so much!

"sb1920alk" wrote:

One way:

If you're referencing A1 from Sheet 1, use =IF(Sheet1!A1<"",Sheet1!A1,"")
instead of =Sheet1!A1.

If you don't care about the values: Tools-Options-View uncheck Zero Values.

"amquintero" wrote:

I am trying to link sheets, if the data in the reference cell in sheet 1 is
blank I would like the corresponding cell in sheet 2 to be blank, currently
it shows zero (0). How di I make it blank?