That does not work. It only transfers info to adjacent cell. I need to
transfer contents from a currently sellected cell to a particular cell, (In
this case from whatever cell is sellected to C2 if blank or C3 if not blank).

"muddan madhu" wrote:

try this
Create a button using forms and assign this macro

Sub test()
Selection.Copy
ActiveCell.Offset(0, 1).Select
ActiveSheet.Paste
Application.CutCopyMode = False
End Sub


On Dec 20, 7:52 am, Gryndar wrote:
The transfer would be initiated by clicking on a button that the macro would
be assigned to.

"Gryndar" wrote:
I need a macro that will transfer contents of a cell that is currently
'selected / highlighted' to another cell, and if that cell is not blank then
to transfer the contents of the 'selected' cell to an alternate cell.
Merry Christmas Everyone!

Thanks,
Guy