Hi
I am trying to copy a cell(eg C1) using an if statement into another
cell (eg B1)

ie. in B1 =IF(A1="copy",C1,"")

However
1. B1 has a list (with validation) which I would like to keep.
2. C1 has a comment which I would like to copy over too.

any help with either

thanks

andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=383014