I have this working, in a fashion
I want the macro to copy paste from the cells then move to the next available row so that when new data is entered in the cells its copying from it will create a log/list (each time the macro is ran)
just now it moves down 1 row, but is reliant on where the cursor is on the 'list' page, I want it to create a row starting from column A each time (or whatever column the start of the data is set to)
just now if you accidentally move the cursor then it wil just start pasting the cells in a row from that cell
Sub Macro19()
'
' Macro19 Macro
'
Sheets("List").Select
Selection.Offset(1, 0).Select
'
Sheets("Temp").Select
Selection.Copy
Sheets("List").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub
I want the macro to copy paste from the cells then move to the next available row so that when new data is entered in the cells its copying from it will create a log/list (each time the macro is ran)
just now it moves down 1 row, but is reliant on where the cursor is on the 'list' page, I want it to create a row starting from column A each time (or whatever column the start of the data is set to)
just now if you accidentally move the cursor then it wil just start pasting the cells in a row from that cell
Last edited: