Data logging with one button

[k31453]

Hi,

I have got this excel sheet.



dota.png

What I want to do is to when I click "Save Trade", I want that to be written in under "Trade Log".

I know programming but I have no clue regarding macro programming.

[KunleExcel]

Dear k31453,

Give me a sample Excel file and i will help you with it.

[KunleExcel]

Attached is macro-enabled sample file.

[NoSparks]

I would use this on the Sheet's module

Sub Button1_Click()

    Dim nr As Long  'next row
    Dim rng As Range
    
Set rng = Range("A7:Q7")
nr = Cells(Rows.Count, "C").End(xlUp).Row + 1

rng.Copy Cells(nr, 1)
rng.ClearContents
Range("A7").Select
Application.CutCopyMode = False

End Sub

[k31453]

Thank you very much everyone