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
|