Validation rule
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.
|