How would this be formated if it was coming from another file altogether?
Im stuck he
=IF(\\SERVER\USERS\username\test1.xls#Sheet2!A1<" ",Sheet2!A1,"")

Thanks for the assistance. Is Excel the best option for attempting to link
files for example for employee time sheets in to a master spreadsheet?

Im sure Excel can do it, but the support literature doesnt articulate how.
Steven



"Domenic" wrote:
Try something like...

=IF(Sheet2!A1<"",Sheet2!A1,"")

Hope this helps!

In article ,
"Lucylambkin" wrote:

I want to insert a formula/function that inserts data from another
spreadsheet, but that if the cells in the other spreadsheet are blank they
are left blank.

I have tried setting up a formula, but if the cell in the other spreadsheet
is blank, then the spreadsheet which has the formula shows a 0 in the cell.

Can anyone help