OK, I'll back out and you can continue on your programming journey.
I did make a couple of changes in the VBA code.
To make it easier to select which month (Prev/Current) the data comes from, I renamed "Private Sub btnPrevMth_Click()" to "Private Sub btnUpdateExcel(TheMonth As String)" and added a few more lines of code.
I renamed the current month button to "btnCurMth"
Code:
Private Sub btnCurMth_Click()
btnUpdateExcel ("C")
End Sub
Private Sub btnPrevMth_Click()
btnUpdateExcel ("P")
End Sub
Private Sub btnUpdateExcel(TheMonth As String)
'rest of code
I'll leave it to you to trace/read through the code......
Good luck with your project......