Data logging with one button

k31453 · #1 06-30-2016, 09:46 PM

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 · #2 07-02-2016, 01:40 AM

Dear k31453,

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

KunleExcel · #3 07-02-2016, 06:55 AM

Attached is macro-enabled sample file.

NoSparks · #4 07-02-2016, 07:53 AM

I would use this on the Sheet's module

Code:

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 · #5 07-03-2016, 04:44 PM

Thank you very much everyone

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to import excel calender data into outlook - with a click of a button	levrone	Excel	24	10-01-2021 05:33 AM
How do I create a personal event logging form?	kton	Office	1	12-22-2014 11:56 PM
Button Filtering Data in a 2010 Report	runswick	Word	1	10-20-2012 11:03 AM
Logging junk mail	iforetnot	Outlook	0	04-14-2011 07:48 AM
autofill data using keywords or button clicks	IG&H	Excel	1	01-17-2010 08:08 AM