Hi guys,

I am trying to populate a worksheet with text in cells from another spreadsheet.  How do I get the formula to ignore blank cells?

At the moment I am using a simple =Sheet1!I3 type formula but the is reutrning cells which have nothing in them.

A little help would be most appreciated!