| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy the contents of a cell in excel to another cell | New Users to Excel | |||
| How can I automatically copy cell contents from one cell into anot | New Users to Excel | |||
| cell function to copy contents of another cell | Excel Worksheet Functions | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Hybrid Mode
