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" wrote in message
...
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


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=519363

Thanks a lot

"Andy" wrote:

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

Andy.

"nick" wrote in message
...
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