VBA to copy a range to another sheet

[Kiwi den]

Looking for VBA code
Start with deleting data in Sheet1 A1 - E1, so I can enter new data
Then I want to copy a range from sheet1 (A1 - E1) to sheet2 starting in A1 - E1,
then when data in sheet 1 changes, it copies to sheet2 in the next available row

Thanks in advance

 

[Logit]

What is your code doing now ?

 

[Kiwi den]

What is your code doing now ?

I havent started yet just looking for some guidance where to start

 

[Logit]

PASTING BETWEEN SHEETS TO NEXT EMPTY ROW

Run Macro If Any Change Made on Sheet in Specified Range

 

[Kiwi den]

PASTING BETWEEN SHEETS TO NEXT EMPTY ROW

Run Macro If Any Change Made on Sheet in Specified Range

Sorry cannot seem to get the code mentioned in this thread (PASTING BETWEEN SHEETS TO NEXT EMPTY ROW)

Sub COPYPASTER()
Sheets("from").Range("A1:S1").Copy
Sheets("to").Cells(Rows.Count, "A").End(xlUp).Offset(1). _
PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=True
Application.CutCopyMode = False
End Sub

 

[Logit]

Sheets("from")

The "from" is the name of the sheet that is being copied. Change FROM to the name of the sheet as shown on the sheet tab. For example : Sheet1

Do the same for the Sheets("to"). Change the TO ... to the name of the sheet where the data is being pasted. For example : Sheet2

 

[Kiwi den]

testing option 2021.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	ORDER NUMBER	DATE	SUPPLIER	CUSTOMER	CUSTOMER O/N	PRODUCT	PRODUCT CODE	QTY	PRODUCT	PRODUCT CODE	QTY	PRODUCT	PRODUCT CODE	QTY	PRODUCT	PRODUCT CODE	QTY	Emailed	Date Arrived
2	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19
from

Cells with Data Validation
Cell	Allow	Criteria
R1	List	Emailed,Telephone,Hand Delivered

I have renamed sheets to reflect the code ( sheet1 = "from") Sheets 2 = "to")

 

[Logit]

Did it work ?

 

[Kiwi den]

Did it work ?

No, I have restarted computer, and still no luck

 

[Logit]

You'll need to be more descriptive of what is happening on your end. A simple YES or NO does not give any description of the problem.