Try something like this:

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

--
Biff
Microsoft Excel MVP


"JessJohns" wrote in message
...
I'm sharing data between two worksheets, but if a cell is blank on the
master
worksheet, how to I get a blank cell on the linked worksheet? It
automatically pulls up a bogus date (i.e. 1/00/00). Is there a way to tell
it
to leave the cell blank, but still have it linked? help please....
Thanks!