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