Create message in linked sheet ---- newbe
 

I am new to programming a workbook.

I have a summary sheet linked to a timecard sheet.

The timecard sheet in cell B33 allows a user to put notes.

I would like the summary sheet, not to copy the notes, but to say
"notes present" if there is text in cell B33 of the timecard
worksheet.

Can you help me

Create message in linked sheet ---- newbe
 

=IF(timecard!B33<"","notes present","")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Good Time" wrote in message
...
I am new to programming a workbook.

I have a summary sheet linked to a timecard sheet.

The timecard sheet in cell B33 allows a user to put notes.

I would like the summary sheet, not to copy the notes, but to say
"notes present" if there is text in cell B33 of the timecard
worksheet.

Can you help me

Create message in linked sheet ---- newbe
 

On Mon, 11 Sep 2006 14:59:59 +0100, "Bob Phillips"
wrote:

=IF(timecard!B33<"","notes present","")
Thank you for your help, its great.

Create message in linked sheet ---- newbe Thank you!
 

On 11 Sep 2006 09:31:03 -0500, Good Time wrote:

On Mon, 11 Sep 2006 14:59:59 +0100, "Bob Phillips"
wrote:

=IF(timecard!B33<"","notes present","")
Thank you for your help, its great.