Originally Posted by
concatch
Hi,
I received some assistance with a macro and I can't seem to fix the date issue. The macro consolidates data from Sheet1 and puts it into a structured format on the tab "Consolidated".
If you look at the Date column on the "Consolidated" tab it will become clear as to what the issue is.
I've also noticed that there are cases where an original date in Sheet1 is 08/01/16 i.e. 8 Jan 2016 (Sheet1 row 3364) and this has now been converted to 2016-08-01 i.e 1 August 2016 (Sheet1 row 3364).
I've attached the workbook with the VBA code. Any help would be greatly appreciated.
Bookmarks