Hi, first let me apologize for my very low knowledge of VBA. If this is not the right place to ask for advices, please let me know.
I am new to VBA and I’m really struggling to make this one. I have succeed to make a VBA to combine data from multiple worksheets, but this one is too difficult to my understanding.
Here is what I need to do:
I have 6 folders, each folder has multiple workbooks with different team names.
Each workbook has a task list with Planned End Date and all workbooks are the same format. The task list vary between hundreds to thousands of tasks depending on the team.
I have a Results workbook in which I need to bring the total of number of tasks planned for all workbooks in the same folder. The results should combine the number os all planned tasks of all workbooks by day. Example: workbook A have 30 tasks planned for Feb/1 and workbook B have 20, then in the results workbook it should input the result for Feb/1 as 50.
I have attached an example of Task List workbook and an example of Results workbook.
I am new to VBA and have no idea how to make this VBA. I was thinking to use countif but I have no idea how to use it on VBA to count in a range in another workbook and then add the result to the result workbook and then loop all workbooks on the same folder and add their results on the same result cell.
Please, please any help, any advice, any examples, anything will be very very welcome and I would be very very grateful.
Bookmarks