In capture one you can see a sample of a sheet I've created.
When the user clicks on the command button "Add Tier 1 Account" I'd like what's visible in the second capture to appear. Additionally, I'd like the total in I5 to include the new line of data.
I've pieced together some VBA code from other posts to come up with something close but I'm having a hard time getting all the way there. My VBA skills are very weak, just started messing around with this to make life easier for work.
Thank you all. If you'd like, I can share my entire project but I was trying to keep this focused on my current hurdle. I'm building a custom (obviously) commission calculation program from my sales team and I want to make it simple to use (hence the cmd buttons) and duplicate when we hire new sales staff.
Here's the code I have in Module 1:
Public Sub cmdinsertRowBelow_Click()
Dim lRow As Long
Dim lRsp As Long
On Error Resume Next
lRow = Selection.Row()
lRsp = MsgBox("Insert new row below " & lRow & "?", _
vbQuestion + vbYesNo)
If lRsp <> vbYes Then Exit Sub
t Shift:=xlDown, CopyOrigin:=xlFormatFromRi
Application.CutCopyMode = False