Forum Discussion
Natalia_G
Mar 15, 2023Copper Contributor
Transform VBA to Office Script
- OliverScheurichGold Contributor
Sub copy_and_paste() Dim i As Long Sheets("BaseDatos").Select Range("A1:B1").Select Selection.Copy Sheets("Documento").Select i = Range("J" & Rows.Count).End(xlUp).Row + 1 Range(Cells(i, 10), Cells(i, 11)).Select ActiveSheet.Paste End Sub
Maybe with this code which determines the first blank cell in column J in sheet "Documento" and pastes the data in columns J and K.