I have 2 spreadsheets in one workbook that contain some of the same data.
I've used the following function to poplutate the data entered into one
spreadsheet into the other with the same data:
=IF('Reg Doc Tracking'!H2,'Reg Doc Tracking'!H2,"")

It works fine with any dates that are entered but I run into a problem when
I have text in the Reg Doc Tracking H2 cell. I need to be able to enter a
date or text into the field and have it populate into the other spreadsheet
that contains the same data.

I'm working with Excel 2003.

Thank,
Karen