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
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