Hi All,
I am looking for help as I am not a pro in VBA but have googled many code and fix my task, however this it is not helping me;
I want to merge 184 excel workbook, where each workbook has 3-5 worksheet, with Workbook name stamp in last column and Sheet tab name in next column following...
Thanks Peter for looking into it again, This calculation has evolved a lot with your inputs and help.
Can you please update the formula to get the info in Overlapping Time Data sheet tab in cell K 20 and the updated Duration 2x. Then I there will not be further any change required but to be...
@Peter Bartholomew ,
This returns a minimum value of 0:00 for the start following the final task of the day - This helps and takes care of the requirement.
Another thing I came across is enclosed for your reference - Whenever multiplicity is 3 the 2x overlapping time not getting calculated...
Hi @Peter Bartholomew ,
Hope you are doing fine,
we have tested the file/calculation couple of things needs to be amended and I require your help again. Below is the screenshot for your reference,
Next start highlighted in pink should be blank as it is picking up the value for next day...
Thank you very much Peter, the updated file fulfills the requirement. I just tested with random data and it worked fine. I will test and it and come back if any help needed.
Thanks again
Anshul
Hi @Peter Bartholomew, hope you are doing fine.
60000 seems very large number of records, though as or now the max what we can think of is 15000 rows not more than that and If it will take time we are ready to do the task on weekly basis or might be two times a week which will help us with...
Thanks @Peter Bartholomew further inputs are required as we have yet not concluded the solution.
The file is working as expected on single tech for single date :awesome:
I have changed data for Task 24 highlighted in pink to check 3x overlapping and also added formula to calculate the...
Below are the answers you are looking for;
Do You would like to get some format or something which would help You?
Yes I would, but first you need to make your understanding clear that you might be champion in Excel and VBA but if someone is providing information in a format which working and...
Please find the enclosed file with data which is populated, though at a given point of time no tech is handling 3 overlapping task.
I have tried to show the same with red line
I am enclosing the file and graph for your reference.
Also the result in OL_Tech sheet column J K L is the result...
Thanks @vletm for working this out, here is what I have understood.
I have tried using different set of data to validate the results you have populated in the OL_TECH sheet, there seems to be I am missing something out, it is not showing the results.
Please find enclosed sheet for your reference.