Copy contents of one cell into another if cell is blank
 

How do I copy the contents of cell B2 into cell D2 if D2 is empty

Copy contents of one cell into another if cell is blank
 

Select Cell B2, Edit Copy, select cell D2, Edit Paste Special Values OK

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"fire9990" wrote:

How do I copy the contents of cell B2 into cell D2 if D2 is empty

Copy contents of one cell into another if cell is blank
 

Copy/paste manually.

Or run a macro.

Sub qwert()
With ActiveSheet.Range("D2")
If .Value = "" Then
.Value = Range("B2").Value
End If
End With
End Sub


Gord Dibben MS Excel MVP

On Fri, 8 Jan 2010 08:13:02 -0800, fire9990
wrote:

How do I copy the contents of cell B2 into cell D2 if D2 is empty