Hello, I have this code to select several rows and copy them to the last row on column f
The default number of columns is always 2, meaning I select a specific number of rows from columns (F) and (G) and copy them. What I want is when copying, column F is copied into G and vice versa for column G, as in the attached image
The default number of columns is always 2, meaning I select a specific number of rows from columns (F) and (G) and copy them. What I want is when copying, column F is copied into G and vice versa for column G, as in the attached image
VBA Code:
Sub macro()
Selection.Copy
With Sheet1.Range("F" & Rows.Count).End(xlUp).Offset(1, 0)
.PasteSpecial xlPasteValues
End With
End Sub