Internal Text Data Source Problem

[RFitzgerald]

Hi All, I'm new to this forum and am a Excel user that has thus far taught myself through trial and error, so please forgive my lacking knowledge of the lingo!

I'm creating a large logistics workbook that needs to use one sheet filled with names and information in a variety of different sheets in the rest of the workbook. For example, the information Sheet 1, column 1, Row 1 needs to go on about 10 other sheets in various places. I've already inserted all of the sourcing correctly (so, if I enter into a cell on sheet one, that information is inserted everywhere else it needs to be in the rest of the workbook). My issue is the BLANK cells on my "source" sheet (sheet 1). I would like those cells to also show up BLANK on the rest of the work book sheets. Right now, on the rest of my sheets any blank cells from my source sheet are reported as "0". I want to get rid of those zeros and have any cell that is blank on my source sheet also show up blank in the rest of my workbook. Can anyone help?

Thanks!
-Rachel

[vlady]

Welcome to the forum.

your can issue an isblank

=IF(ISBLANK(your formula),"",yourformula) - "" is space
if you could post your formula it is better, so we'll know on what to use.

[TMS]

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

Or, if it's text in the cell, just:

='Sheet1'!A1&""


Regards, TMS

[TMS]

"" is not "space", it's null/empty, whatever you want to call it ... " " is a space

Regards, TMS

[RFitzgerald]

THANK YOU both! vlady- that worked perfectly!