excel macro help please

Soldato
Joined
14 Dec 2005
Posts
5,047
I have this working, in a fashion

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:
Great thanks. Just new to this (took me hours to get that working last night...30mins to access the developer tab!)
So don't mind trying to figure it out!
 
Back
Top Bottom