Office Scripts

[jaspers]

Thanks in advance new to using scripts vs VBA.
looking for advice on a couple things that i had previously done with VBA and this is my first time attempting to use scripts

Recording data - looking for a method to have the script button take the data inputs of A2:B2 and add them to the next open line in the table below (A3:B400)

Time stamp - i would like cell C4 to be a time stamp of when the data was entered in A4:B4

Any advice is much appreciated Thanks

 

[SunnyAlv]

like this ?

Sub jasper()
Application.ScreenUpdating = False

    Dim ws As Worksheet, ls As Long
    Set ws = ActiveSheet
    ls = ws.Cells(Rows.Count, 1).End(xlUp).Row

        With ws
            .Range("A2:B2").Copy .Range("A" & ls + 1)
            .Range("A" & ls + 1).Offset(, 2).Value = Format(Now(), "DD/MM/YY H:MM AM/PM")
        End With
        
MsgBox "Successfull"
End Sub

 

[jaspers]

I will be running this in online office 365 so i cannot use VBA