Creating a time series from data grouped in months for multiple years
Hello Excel_lent community!
I need to create a time series out of data that are grouped by month for many years. These are data for rainfall events. I am attaching an Excel file that will explain everything. The code that I have worked out thus far is also included but it is not doing what I want. Any help is appreciated !
Re: Creating a time series from data grouped in months for multiple years
Private Sub CommandButton1_Click()
Dim sim As Double, j As Double, m As Double
Dim year As Double, column As Double
Dim month As Double, row As Double, ss As Double
sim = Cells(1, 1) ' count values
m = 60 ' starting row from where the code outputs the value
row = 1
column = 2
For year = 2038 To 2070 ' number of years
For month = 1 To 12 ' number of months
For i = 1 To sim