I've tried searching for a few hours on this but I couldn't find exactly what I was looking for.
Is there way to create a macro to copy a few cells from one workbook and paste them into another at the bottom of the next open cell?
I found this code to get to the bottom of a page but that's as far as I got.
Sub FindFirstCellNextRow()
Dim x As Integer
x = ActiveSheet.UsedRange.Rows.Count
ActiveCell.SpecialCells(xlLastCell).Select
ActiveCell.EntireRow.Cells(1, 1).Offset(1, 0).Activate
End Sub
Any help would be greatly appreciated!
Is there way to create a macro to copy a few cells from one workbook and paste them into another at the bottom of the next open cell?
I found this code to get to the bottom of a page but that's as far as I got.
Sub FindFirstCellNextRow()
Dim x As Integer
x = ActiveSheet.UsedRange.Rows.Count
ActiveCell.SpecialCells(xlLastCell).Select
ActiveCell.EntireRow.Cells(1, 1).Offset(1, 0).Activate
End Sub
Any help would be greatly appreciated!