Dealing with Text in a Function cell
 

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

Dealing with Text in a Function cell
 

Hi!

Try this:

=IF('Reg Doc Tracking'!H2<"",'Reg Doc Tracking'!H2,"")

Biff

"Karen" wrote in message
...
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

Dealing with Text in a Function cell
 

That did it! Thanks!

"Biff" wrote:

Hi!

Try this:

=IF('Reg Doc Tracking'!H2<"",'Reg Doc Tracking'!H2,"")

Biff

"Karen" wrote in message
...
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

Dealing with Text in a Function cell
 

You're welcome!

Biff

"Karen" wrote in message
...
That did it! Thanks!

"Biff" wrote:

Hi!

Try this:

=IF('Reg Doc Tracking'!H2<"",'Reg Doc Tracking'!H2,"")

Biff

"Karen" wrote in message
...
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