Although I've managed to create some simple macros successfully, the problem I have at present seems beyond my abilities, so I'd be grateful for some pointers please!! - does a A VBA script already exist that will do this?
I have series of files with 4 long data columns:
Identifier Date Time Value 123456 dd/mm/yyyy hh:mm 12.3
They contain data from 15 days recorded every 15 minutes
I wish to create a macro to automate the process of re-tabulating the values from column 4 into a table sorted by date and time with 15 columns (one for each day) and 96 rows (one for each 15 minutes of the 24hr day) so that
any value recorded between midnight and 00:14 appears in row 1,
00:15 - 00:29 in row 2 etc etc
There are occasional data gaps and for these cells in the table I'd like a blank to be recorded