Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2016, 09:51 AM
carlos_cs carlos_cs is offline Timeline - fill sheet with the missing dates between given interval Windows 10 Timeline - fill sheet with the missing dates between given interval Office 2013
Novice
Timeline - fill sheet with the missing dates between given interval
 
Join Date: May 2016
Posts: 6
carlos_cs is on a distinguished road
Default Timeline - fill sheet with the missing dates between given interval

I have the following Excel problem:


I currently have this in sheet1 columns A,B,C:


Date Time Worker
04/04/2016 4,5 John
05/04/2016 2 John
06/04/2016 6,5 John
07/04/2016 0 --
08/04/2016 0,5 Charles
08/04/2016 2 John
08/04/2016 0,5 William
09/04/2016 0 --
10/04/2016 0 --
11/04/2016 9 John
11/04/2016 3,75 William


I also have:
The Creation date of Project In cell E1 : 28/03/2016
The Actual start of Project In cell E2: 29/03/2016
The Today date In cell E3 (let's consider today date is the one i show next): 13/04/2016


What I want in sheet2:

Choose the earliest date between Creation and Actual start of Project, which in this case is 28/03/2016
Then add the missing dates with 0 Time and -- Worker until it reaches the Today date.
It should look like this after all done:

Date Time Worker
28/03/2016 0 --
29/03/2016 0 --


30/03/2016 0 --
31/03/2016 0 --
01/04/2016 0 --
02/04/2016 0 --
03/04/2016 0 --
04/04/2016 4,5 John
05/04/2016 2 John
06/04/2016 6,5 John
07/04/2016 0 --
08/04/2016 0,5 Charles
08/04/2016 2 John
08/04/2016 0,5 William
09/04/2016 0 --
10/04/2016 0 --
11/04/2016 9 John
11/04/2016 3,75 William
12/04/2016 0 --
13/04/2016 0 --


It is the continuation of a problem i had but only detected now:
excel - Timeline - loop through all dates between first and last given and add date to column if not found - Stack Overflow
Looking for a excel-vba macro solution because i believe it's the only way to do it.
I'm new to VBA and stuck with this problem and all the help means a lot to me!
Reply With Quote
  #2  
Old 05-05-2016, 03:22 AM
carlos_cs carlos_cs is offline Timeline - fill sheet with the missing dates between given interval Windows 10 Timeline - fill sheet with the missing dates between given interval Office 2013
Novice
Timeline - fill sheet with the missing dates between given interval
 
Join Date: May 2016
Posts: 6
carlos_cs is on a distinguished road
Default

I uploaded an example with slightly different values with what I have.
Attached Files
File Type: xlsm timeline.xlsm (18.8 KB, 10 views)
Reply With Quote
Reply

Tags
excel-vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Timeline - fill sheet with the missing dates between given interval Timeline - loop through all dates between first and last given and add date to column if not found carlos_cs Excel Programming 1 05-03-2016 09:25 AM
Timeline - fill sheet with the missing dates between given interval how to fill a series of dates mcd23379 Excel 1 03-30-2016 10:19 PM
Timeline - fill sheet with the missing dates between given interval Help needed: How can I insert regular interval dates in excel row joneill Excel 5 11-24-2014 10:25 AM
Timeline - fill sheet with the missing dates between given interval Help Coloring a cell in Sheet one if data is missing from another sheet Aeducan Excel 1 06-22-2014 04:49 PM
Timeline - fill sheet with the missing dates between given interval MS Project 2010 timeline pan and zoom bar missing cossie2k Project 1 05-22-2013 06:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft