Timeline - loop through all dates between first and last given and add date to column if not found

carlos_cs · #1 05-02-2016, 07:35 AM

what i have in columns A, B, C:

Date Hours Name
01/03/2016 8,0 John
02/03/2016 8,0 John
08/03/2016 7,5 John
08/03/2016 2,0 Charles
08/03/2016 2,0 William
10/03/2016 3,5 Charles
11/03/2016 3,7 Charles
14/03/2016 2,2 Charles
15/03/2016 8,0 John
16/03/2016 8,0 John

what i want in column A, B, C in another sheet:

Date Hours Name
01/03/2016 8,0 John
02/03/2016 8,0 John
03/03/2016 0,0 -
04/03/2016 0,0 -
05/03/2016 0,0 -
06/03/2016 0,0 -
07/03/2016 0,0 -
08/03/2016 7,5 John
08/03/2016 2,0 Charles
08/03/2016 2,0 William
09/03/2016 0,0 -
10/03/2016 3,5 Charles
11/03/2016 3,7 Charles
12/03/2016 0,0 -
13/03/2016 0,0 -
14/03/2016 2,2 Charles
15/03/2016 8,0 John
16/03/2016 8,0 John

It has to work with any given dates, hours and names!

Please help i really need this!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Autofill dates - how can I get the same date and consecutive dates?	Exhale	Excel	3	04-05-2016 03:11 AM
Loop Macro to Edit Date	damaniam	Word VBA	7	02-21-2014 07:12 AM
Loop action in Word until not found	kilburfi	Word VBA	2	07-12-2013 01:26 AM
Timeline date format	mikeg	Project	1	04-19-2013 06:26 AM
Automatically enter date into a column and make that column read only	Mr Davo	Excel	1	10-29-2012 01:07 AM