Hi everyone.
I'm wondering if anyone could help me.
I have around 800 workbooks with about 30 sheets each. They all have different filenames and sheet names. And they are in different folders.
The only thing they have in common is that all the data is in the same cell position.
In order to organize the data I need some kind of function/code wich can retrieve the data on command.
For example:
In each file there is a value that only appears on that file. That value is always in the same cell position. So by entering that value is it possible for the code to retrieve all the data present in the file that has that value?
Could you guys help me with this?
Bare in mind that I have no knowledge of VBA coding. So if possible could you walk me through it?
Thanks in advance for your help.
I'm wondering if anyone could help me.
I have around 800 workbooks with about 30 sheets each. They all have different filenames and sheet names. And they are in different folders.
The only thing they have in common is that all the data is in the same cell position.
In order to organize the data I need some kind of function/code wich can retrieve the data on command.
For example:
In each file there is a value that only appears on that file. That value is always in the same cell position. So by entering that value is it possible for the code to retrieve all the data present in the file that has that value?
Could you guys help me with this?
Bare in mind that I have no knowledge of VBA coding. So if possible could you walk me through it?
Thanks in advance for your help.
