Hello,
Need help with creating this macro as I do not know how to do it. Any help is appreciated.
I have one sheet called 'Raw Data' the following information is given
A B C D E (Column Letter)
Plant START DATE TIME END DATE TIME Location Reason
Plant 2 Jan 2, 2019 12:00:00 AM Jan 4, 2019 11:59:00 PM Area 1 Reason 3
Plant 3 Jan 11, 2019 8:38:41 AM Jan 11, 2019 9:30:00 AM Area 1 Reason 2
Plant 2 Jan 16, 2019 12:00:00 AM Jan 25, 2019 11:59:00 PM Area 2 Reason 2
Plant 4 Mar 6, 2019 12:00:00 AM Mar 6, 2019 12:37:00 PM Area 4 Reason 1
Plant 1 Apr 3, 2019 7:00:00 AM Apr 3, 2019 7:30:00 AM Area 1 Reason 1
I am trying to copy the raw data onto another sheet in the same workbook, but if start date =/= end date, then end date = start date, add a new line and paste the same info as the previous line. Goal: Have the start and end date to be the same date. So the above table would be shown like the following (after the macro)
A B C D E (Column Letter)
Plant START DATE TIME END DATE TIME Location Reason
Plant 2 Jan 2, 2019 12:00:00 AM Jan 2, 2019 11:59:00 PM Area 1 Reason 3
Plant 2 Jan 3, 2019 12:00:00 AM Jan 3, 2019 11:59:00 PM Area 1 Reason 3
Plant 2 Jan 4, 2019 12:00:00 AM Jan 4, 2019 11:59:00 PM Area 1 Reason 3
Plant 3 Jan 11, 2019 8:38:41 AM Jan 11, 2019 9:30:00 AM Area 1 Reason 2
Plant 2 Jan 16, 2019 12:00:00 AM Jan 16, 2019 11:59:00 PM Area 2 Reason 2
Plant 2 Jan 17, 2019 12:00:00 AM Jan 17, 2019 11:59:00 PM Area 2 Reason 2
Plant 2 Jan 18, 2019 12:00:00 AM Jan 18, 2019 11:59:00 PM Area 2 Reason 2
Plant 2 Jan 19, 2019 12:00:00 AM Jan 19, 2019 11:59:00 PM Area 2 Reason 2
Plant 2 Jan 20, 2019 12:00:00 AM Jan 20, 2019 11:59:00 PM Area 2 Reason 2
Plant 2 Jan 21, 2019 12:00:00 AM Jan 21, 2019 11:59:00 PM Area 2 Reason 2
Plant 2 Jan 22, 2019 12:00:00 AM Jan 22, 2019 11:59:00 PM Area 2 Reason 2
Plant 2 Jan 23, 2019 12:00:00 AM Jan 23, 2019 11:59:00 PM Area 2 Reason 2
Plant 2 Jan 24, 2019 12:00:00 AM Jan 24, 2019 11:59:00 PM Area 2 Reason 2
Plant 2 Jan 25, 2019 12:00:00 AM Jan 25, 2019 11:59:00 PM Area 2 Reason 2
Plant 4 Mar 6, 2019 12:00:00 AM Mar 6, 2019 12:37:00 PM Area 4 Reason 1
Plant 1 Apr 3, 2019 7:00:00 AM Apr 3, 2019 7:30:00 AM Area 1 Reason 1
Bookmarks