Re: Linked data

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 01/07/05


Date: Fri, 07 Jan 2005 12:50:11 -0700

One way:

    =IF(Sheet1!A1<>"","X","")

In article <EEAB2377-134B-43C9-8267-2764903A8483@microsoft.com>,
 "Task Lead Nicole" <Task Lead Nicole@discussions.microsoft.com> wrote:

> Is there a way to create a macro or formula or a cell format to populate a
> cell that is getting info (external data) from a link to a cell in another
> work*** so that it just inserts an "X" or something like that IF the source
> cell is NOT NULL (or not empty)?


Quantcast