Date, Time and Data auto sort fill etc

[Bebbspoke]

Hi Folks; - PLEASE; - Raw data is as follows; - Row#1 is headings - all subsequent are data:

Col#A given as Date & Time in format "dd\/mm\/yyyy hh:mm:ss (newest to oldest)" in 1 (one) minute stamps but has some stamps missing.
Col#B thru I is numeric data.

Fill Requirements; -

1/ Col#A reformat to "ddd.dd/mm/yy hh:mm (oldest to newest)" in 1 (one) minute intervals.

2/ Fill: - Col#A missing 1 (one) minute stamps and Col#B thru I with last known data.

3/ Auto filled rows to appear in coloured Italics for identification.

Please will some kind person write me a macro to do this as I have several large data files to process and will repeated get the problem with new data. Thank you.

Cheers, Bebbspoke

 

[Bebbspoke]

Example data as received: -

16/08/2016 00:20:00	1.11818	1.11823	1.11818	1.11820	1.11816	1.11820	1.11816	1.11820
16/08/2016 00:18:00	1.11834	1.11834	1.11811	1.11813	1.11829	1.11829	1.11807	1.11809
16/08/2016 00:17:00	1.11831	1.11834	1.11827	1.11834	1.11827	1.11830	1.11824	1.11829
16/08/2016 00:14:00	1.11838	1.11840	1.11826	1.11826	1.11835	1.11837	1.11822	1.11822
16/08/2016 00:13:00	1.11864	1.11864	1.11837	1.11838	1.11860	1.11861	1.11834	1.11835
16/08/2016 00:12:00	1.11864	1.11864		1.11864	1.11860	1.11860	1.11860	1.11860
16/08/2016 00:11:00	1.11864	1.11865	1.11863	1.11864	1.11860	1.11861	1.11860	1.11860
16/08/2016 00:10:00	1.11864	1.11866	1.11864	1.11864	1.11861	1.11862	1.11860	1.11860
16/08/2016 00:09:00	1.11866	1.11866	1.11864	1.11864	1.11861	1.11861	1.11861	1.11861
16/08/2016 00:08:00	1.11860	1.11866	1.11860	1.11866	1.11856	1.11861	1.11856	1.11861
16/08/2016 00:07:00	1.11858	1.11860	1.11858	1.11860	1.11855	1.11856	1.11855	1.11856
16/08/2016 00:06:00	1.11858	1.11859	1.11857	1.11858	1.11855	1.11855	1.11855	1.11855
16/08/2016 00:04:00	1.11859	1.11859	1.11857		1.11856	1.11856	1.11854	1.11855
16/08/2016 00:03:00	1.11859	1.11860	1.11859		1.11857	1.11857	1.11855	1.11856
16/08/2016 00:02:00	1.11860	1.11860	1.11857	1.11859	1.11856	1.11857	1.11854	1.11857
15/08/2016 23:57:00	1.11863	1.11864	1.11863	1.11863	1.11858	1.11858	1.11857	1.11857
15/08/2016 23:56:00	1.11864	1.11866	1.11862	1.11863	1.11859	1.11861	1.11857	1.11858
15/08/2016 23:55:00	1.11858	1.11864	1.11858	1.11864	1.11854	1.11859		1.11859
15/08/2016 23:54:00	1.11860	1.11860	1.11858	1.11858	1.11856	1.11857		1.11854
15/08/2016 23:53:00	1.11859	1.11860	1.11858	1.11860	1.11855	1.11857		1.11856
15/08/2016 23:52:00	1.11859	1.11860	1.11859	1.11859	1.11854	1.11856	1.11854	1.11855
15/08/2016 23:51:00	1.11858	1.11861	1.11858	1.11859	1.11854	1.11857	1.11854	1.11854
15/08/2016 23:50:00	1.11856	1.11859	1.11856	1.11858	1.11853	1.11854	1.11851	1.11854
15/08/2016 23:48:00	1.11860	1.11862	1.11860	1.11860	1.11856	1.11857	1.11854	1.11855
15/08/2016 23:47:00	1.11862		1.11860	1.11860	1.11859	1.11859	1.11855	1.11856
15/08/2016 23:46:00	1.11861	1.11863	1.11860	1.11862	1.11854	1.11859	1.11853	1.11859
15/08/2016 23:45:00	1.11849	1.11861	1.11849	1.11861	1.11843	1.11858	1.11843	1.11854
15/08/2016 23:43:00	1.11865	1.11868	1.11859	1.11862	1.11862	1.11865	1.11859	1.11859
15/08/2016 23:42:00	1.11865	1.11867	1.11860	1.11865	1.11859	1.11862	1.11857	1.11862
15/08/2016 23:41:00	1.11862	1.11868	1.11862	1.11865	1.11865		1.11858	1.11859
15/08/2016 23:40:00	1.11870	1.11870	1.11857	1.11862	1.11861	1.11865	1.11854	1.11865

<colgroup><col><col span="8"></colgroup><tbody>
</tbody>