View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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