Copy if adjacent Cell has data
OR may be
Range("A2").value=Range("b2").value
--
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
In Cell A2
=B2
If this post helps click Yes
---------------
Jacob Skaria
"Jeff Gross" wrote:
I need to copy text into a cell "A2" if there is any data in "B2". B2
contains a formula but will appear blank if its source has nothing.
Any ideas?
Jeff
|