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
>
>