Copy Cell Value Above

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know Shift+Cntrl+' will Copy Cell Value Above, is there a way to Copy Cell Value 2 cells to the left?
 
You could use a simple macro and assign it to a shortcut
key or button:

Sub Copy2toLeft()
With ActiveCell
If .Offset(, -2).Value = "" Then
MsgBox "Nothing found!"
Else
.Offset(, -2).Copy
.PasteSpecial
Application.CutCopyMode = False
End If
End With
End Sub

--
Press ALT+F11, click on Personal.xls, Insert > Module, and
paste this in.

HTH
Jason
Atlanta, GA
-----Original Message-----
I know Shift+Cntrl+' will Copy Cell Value Above, is there
Click to expand...
a way to Copy Cell Value 2 cells to the left?
 
Back
Top