VBA Help Required

[Camilla1980]

I am completely ignorant of all things VBA and would be unbelievably grateful if someone could help me with this scenario:
I, along with other colleagues, complete 6 different tasks numerous times a day and capture each completed task on the relevant spreadsheet (6 spreadsheets in total - let’s call them a1,b2,c3,d4,e5,f6) each task is listed individually and so I could have 30 entries on each of the 6 sheets per day.
Other than the name, all spreadsheets are identical in layout with columns A-H.
The date is entered in column D
The colleague’s name is entered in column F
When task is done, ‘completed’ is entered in column H

I’d like to capture the number of times I’ve completed each of the tasks, by volume per day, based on when ‘completed’ is entered in column H on the original spreadsheets.
So I have a summary spreadsheet where I’d like to import the data, with the dates listed in A2-A32 and the 6 tasks listed in B2-G2.
Any advice would be be amazing - thanks in advance!

 

[XLfriend777]

Hi Camilla1980. I hope this response helps get things started. Is there any reason you don't have all this data in one spreadsheet with a tab each for a1, b2, c3, d4, e5 and f6 and then with a Summary tab? That may simplify things. Let us know your thoughts. Hope this helps.

 

[Camilla1980]

Hi goesr,
Thanks for the speedy response but unfortunately, the spreadsheets need to be separate. They contain personal data and so to collate them could be a data privacy issue as not all colleagues have access to all sheets.
I suppose even if they were in a workbook on separate tabs, I'd still need to collate the data from the individual sheets by date.
Many thanks for the suggestion, though.