| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a pop-up message prior to opening sheet | Excel Discussion (Misc queries) | |||
| Error message #N/A appears in linked cells | Links and Linking in Excel | |||
| Error message help with linked worbook | Excel Discussion (Misc queries) | |||
| DV message linked | Excel Discussion (Misc queries) | |||
| Linked table message in VBA | Excel Programming | |||
Linear Mode
