For copy paste macro for excel at first copy the data from Row 2 and copy it into your desired row. Continue down the list until there are not more records. Then delete the 2nd row, and continue going down. After that continue down the list until the last record.
You can either select cell, ctrl-c, and ctrl-v in new location (refering cells will change) or click cell, click the text up top, ctrl-c, and escape out of it.
You must click in the cell you want to apply the Macro using the easy Macro creater in the Tools menu of Microsoft's Excel program. From there is an easy creator to add a new Macro that takes you through the individual steps.
Excel document are spilit into more cells this cells are called macros. First one cell data are selected and then that data are copied next cursor are move to the next cells and then paste the require text are pasted next we will using this text, old text are removed.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target. Address = "$V$4" Then
Target. Copy
Me. Paste Me. Range("$K$12")
End If
End Sub
if you are not going to do anything more than keeping the contents of two cells in sync, you might want to consider a simpler way to do the same thing. Y
