Trying to write a macro that takes a group of cells from a sheet named "Master" and be able to run the macro to insert that group of cells at the first blank row on sheet 2. Then if ran again inserts those cells again at the first blank row. I named the group of cells on sheet "Master" as New_Job. They are A1:Q15.
Here is the code I wrote but errors on the Range("New_Job").Select
Sub newend()
'
' newend Macro
Range("New_Job").Select
Selection.Copy
Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=6
End Sub
Not sure if this is the way to go but after I get this to work I need to copy sheet 2 to a new sheet and have the macro work on that sheet as well. Inserting those same cells to the bottom from sheet "Master"
Here is the code I wrote but errors on the Range("New_Job").Select
Sub newend()
'
' newend Macro
Range("New_Job").Select
Selection.Copy
Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
ActiveWindow.SmallScroll Down:=6
End Sub
Not sure if this is the way to go but after I get this to work I need to copy sheet 2 to a new sheet and have the macro work on that sheet as well. Inserting those same cells to the bottom from sheet "Master"