How can I create a vba to copy the data from col c to columns F:AC for multiple days with cell e1 to be Oct 1st ed to be Oct 2 and so on for a full month?
Example of the data set is below: columns A:C is the month of October for 24 hours
Example of the data set is below: columns A:C is the month of October for 24 hours
10/01/2020 | 12:00:00 | 0.211 | 10/01/2020 | 0.211 | 0.25 | 0.35 | |
10/01/2020 | 1:00:00 | 0.25 | 10/02/2020 | ||||
10/01/2020 | 2:00:00 | 0.35 |