JoaoNorris
02-19-2020, 05:31 AM
Hello everyone,
I recently started working with VBA and I'm facing a problem with turning a single column into a matrix.
So, I have data in steps of 15 minutes for an entire month (4x24(hours)x31(days) = 2 976) resulting in a column of 2976 inputs. What I have to do is getting columns of 96 rows (equals each day), resulting in a matrix with 96 rows and 31 columns.
I tried doing a for loop but couldn't make it work since i didn't know how to start the next iteration on the 97th row, to place it on the second column and so on.
I know this is really basic, but if anyone could help I would be very thankfull,
Best regards!
I recently started working with VBA and I'm facing a problem with turning a single column into a matrix.
So, I have data in steps of 15 minutes for an entire month (4x24(hours)x31(days) = 2 976) resulting in a column of 2976 inputs. What I have to do is getting columns of 96 rows (equals each day), resulting in a matrix with 96 rows and 31 columns.
I tried doing a for loop but couldn't make it work since i didn't know how to start the next iteration on the 97th row, to place it on the second column and so on.
I know this is really basic, but if anyone could help I would be very thankfull,
Best regards!