New to VBA, and making slow progress.
I am trying to make my life easier by coding a long winded process to transfer stats from the current week to the sheet for the current month. So, all stats for week commencing 25 Feb, should be transferred to the worksheet February, then deleted from the original sheet and the date updated. I have managed to do all of this, but I am struggling to get the code to select the sheet with the month automatically.
I have managed to get the month extracted from the cell holding the value for the week commencing date, but do not know how to use that to determine the sheet I want to select
I have tried the following (Sheet Z1 Cell B:17 holds the relevant month as text):
Dim strSheet As String
When I run the macro, I keep getting the error: Runtime error 9: Subscript out of range.
Does anybody have an idea how I can do this?
I tried to attach the (very basic) spreadsheet, but somehow couldn't..