Code to insert data from list between two rows
01/01/2015 00:00 4.64 01/01/2015 05:21 1.65
01/01/2015 11:35 4.95
01/01/2015 17:42 1.7
01/01/2015 01:00 3.89
01/01/2015 02:00 2.98
01/01/2015 03:00 2.25
01/01/2015 04:00 1.84
01/01/2015 05:00 1.66
01/01/2015 06:00 1.72
01/01/2015 07:00 2.15
01/01/2015 08:00 2.89
01/01/2015 09:00 3.71
01/01/2015 10:00 4.42
01/01/2015 11:00 4.87
01/01/2015 12:00 4.91
01/01/2015 13:00 4.45
01/01/2015 14:00 3.61
01/01/2015 15:00 2.71
01/01/2015 16:00 2.08
01/01/2015 17:00 1.77
01/01/2015 18:00 1.72
I have data in list as shown above and want to insert the data on right hand side between the relevant rows.
The first row of data should be between 05:00 & 06:00
the second between 11:00 & 12:00
the third between 17:00 & 18:00
What code will insert the info and can be expanded to complete 1 month's data?
Thanks
Recent comments
5 years 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago