If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|