Hi team,
I've been searching for weeks on how to complete this task but I can not even get a starting point. All I have managed to do is turn off certain aspects of excel to make the coding run more efficiently.
I cant write my own code but I've been able to understand what I find online until now. While I would like a solution. If it could be written with explanations to each section so I can learn to use the code again or even just explain the solution. I would be very grateful.
The Problem
I have a folder of files.
Each file has multiple tabs named for a person. First and last name. E.g. John Smith. These are dynamic but are limited to 10 people.
In each worksheet. There are 2 specific cell values I want to target, Their name and if a certain cell has an "x" in it.
The solution I want.
I want to create a Master sheet that has a list of these names.
I want to push a button.
I want to have a dialog box to open, which I can then navigate to the specific folder and select the specific files.
It should loop through all the files I select, look in cell G31, if it finds an "x" look in cell D6 (which contain the person name) Then use the name as a reference to add a total next to their name on the master sheet. Like a countif.
So if across 3 workbooks there are 4 instances for John Smith that have an "x" in G31 it should count those and add them to his tally. Counting up until all sheets are read through.
I would consider myself an amateur at this. Explanations are highly regarded.
Look forward to your help.
I've been searching for weeks on how to complete this task but I can not even get a starting point. All I have managed to do is turn off certain aspects of excel to make the coding run more efficiently.
I cant write my own code but I've been able to understand what I find online until now. While I would like a solution. If it could be written with explanations to each section so I can learn to use the code again or even just explain the solution. I would be very grateful.
The Problem
I have a folder of files.
Each file has multiple tabs named for a person. First and last name. E.g. John Smith. These are dynamic but are limited to 10 people.
In each worksheet. There are 2 specific cell values I want to target, Their name and if a certain cell has an "x" in it.
The solution I want.
I want to create a Master sheet that has a list of these names.
I want to push a button.
I want to have a dialog box to open, which I can then navigate to the specific folder and select the specific files.
It should loop through all the files I select, look in cell G31, if it finds an "x" look in cell D6 (which contain the person name) Then use the name as a reference to add a total next to their name on the master sheet. Like a countif.
So if across 3 workbooks there are 4 instances for John Smith that have an "x" in G31 it should count those and add them to his tally. Counting up until all sheets are read through.
I would consider myself an amateur at this. Explanations are highly regarded.
Look forward to your help.
