JohnWaveDoe
03-21-2012, 07:26 AM
Hi all,
I'm very new in VBA and Excel macros,
I need someone to expain me how I can compare dates from Sheet1, Column A, (dates are sorted asc) and if new range of dates are "newer" than previous, then copy that range in new sheet which is dynamically created and have name of date.
That means, that output is sheet1.range("A") is header (DateTime) and sorted dates.
And other sheets with name of unique date and in range of that dates from first sheet.
Example input: Example output:
SheetName:03.10.08. SheetName:04.10:08. etc.
DateTime DateTime DateTime etc.
--------- --------- ---------
03.10.08. 08:22:13 03.10.08. 08:22:13 04.10.08. 08:25:13 etc.
03.10.08. 08:25:13 03.10.08. 08:25:13
04.10.08. 08:25:13
05.10.08. 08:34:13
I'm very new in VBA and Excel macros,
I need someone to expain me how I can compare dates from Sheet1, Column A, (dates are sorted asc) and if new range of dates are "newer" than previous, then copy that range in new sheet which is dynamically created and have name of date.
That means, that output is sheet1.range("A") is header (DateTime) and sorted dates.
And other sheets with name of unique date and in range of that dates from first sheet.
Example input: Example output:
SheetName:03.10.08. SheetName:04.10:08. etc.
DateTime DateTime DateTime etc.
--------- --------- ---------
03.10.08. 08:22:13 03.10.08. 08:22:13 04.10.08. 08:25:13 etc.
03.10.08. 08:25:13 03.10.08. 08:25:13
04.10.08. 08:25:13
05.10.08. 08:34:13