Validation rule

Hi,

I am trying to populate data from WS1 to WS2 with some validation rules. In
this scenario I want to put in a validation rule where, if A1 in worksheet 1
is not blank (have a character) then a default value 'x' should be populated
in A1 of ws2. ANy help would be highly appreciated. Thanks.

Hi
You could use a formula in A1 of Sheet2:
=IF(Sheet1!A1<>"","x")

Andy.

"nick" <nick@discussions.microsoft.com> wrote in message
news:F9080941-84CB-49C8-8230-F59D7FB7A918@microsoft.com...
> Hi,
>
> I am trying to populate data from WS1 to WS2 with some validation rules.
> In
> this scenario I want to put in a validation rule where, if A1 in worksheet
> 1
> is not blank (have a character) then a default value 'x' should be
> populated
> in A1 of ws2. ANy help would be highly appreciated. Thanks.

Hi Nick

In Ws2 A1

=IF(WS1!A1<>"",value,"")

this will put in a value you define if not blank otherwise it will be blank

Ed

Thanks a lot

"Andy" wrote:

> Hi
> You could use a formula in A1 of Sheet2:
> =IF(Sheet1!A1<>"","x")
>
> Andy.
>
> "nick" <nick@discussions.microsoft.com> wrote in message
> news:F9080941-84CB-49C8-8230-F59D7FB7A918@microsoft.com...
> > Hi,
> >
> > I am trying to populate data from WS1 to WS2 with some validation rules.
> > In
> > this scenario I want to put in a validation rule where, if A1 in worksheet
> > 1
> > is not blank (have a character) then a default value 'x' should be
> > populated
> > in A1 of ws2. ANy help would be highly appreciated. Thanks.
>
>
>

Thanx a lot

"EdMac" wrote:

>
> Hi Nick
>
> In Ws2 A1
>
> =IF(WS1!A1<>"",value,"")
>
> this will put in a value you define if not blank otherwise it will be
> blank
>
> Ed
>
>
> --
> EdMac
> ------------------------------------------------------------------------
> EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
> View this thread: http://www.excelforum.com/showthread...hreadid=519363
>
>