Dear Sir
Please find attached test file.
I am simply using this code to copy data from one cell to another
What I want that I have a date from G13:G23, if I press first button G23
its data should be copied from cell G23 and paste in first available empty cell between range C13:C23
Please help
Please find attached test file.
I am simply using this code to copy data from one cell to another
Code:
Sub Copy1()
Range("G13").Select
Selection.Copy
Range("C13").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End Sub
its data should be copied from cell G23 and paste in first available empty cell between range C13:C23
Please help