Help creating a macro button

Hi,

Absolute beginner here.

I would like a button which adds any number in column L to adjacent number in column I and then clear column L on each row.

So as per attachment on Row 6 $3,500.00 + $4,500.00 = $8000.00 (new total for I6) L6 now empty cell and so on down the page.

Note this test spreadsheet is a cut down version of a much larger sheet.

eg: as per attached sheet

Kind Regards,
Glenn

Hi,

Try this.

I have inserted some comments in the VBA that need your attention. To access these comments, right click on the worksheet name "MASTER" and select "View Code". Anything written in green is a comment, and is either something that requires your attention, or is informing you that you no longer need to change anything below a certain point in the code.

I hope this helps you

thank you that's exactly what I need. Can I copy this macro and button easily into a new spread sheet?

Cheers!
Glenn

Yes you can, but you will need to make sure that row and column numbers match those consistent with the new sheet that you paste the macro into.

Please don't forget to mark this thread as solved and click the * next to my post to say thank you

Have a nice day!

One more small thing is below correct wording and placement to stop at row 200??

Private Sub CommandButton1_Click()
Dim i As Double
Dim startRow As Double

'This is what you want the button to say
CommandButton1.Caption = "CALCULATE"

'This is the first row in column L that you want the macro to look at
startRow = 14
endRow = 200
'You do not need to change anything else after this point
With ActiveSheet
For i = startRow To .Cells(.Rows.Count, "L").End(xlUp).Row
If IsNumeric(.Cells(i, "L").Value) Then
'Sum column I and L
.Cells(i, "I").Value = .Cells(i, "I").Value + .Cells(i, "L").Value
'Reset column L
.Cells(i, "L").Value = ""
End If
Next i
End With
End Sub

Yep it sure is. The only thing you should need to change for that to take effect is the initial value of "endRow" (sorry, I just noticed that I forgot to put a comment on that line!). But what you have there looks fine to me.

Please don't forget to mark this thread as solved and click the * next to my post to say thank you

Are you being sarcastic? :P

I suppose the alternative approach would have been

Please Login or Register  to view this content.

amongst many other possible methods of achieving the same outcome