Forum Discussion
Search a text into a folder containing worksheets with different names and copy values
Hello all, I am searching for a solution in excel to search for some data into a specific folder which contains more worksheets with different name and if the text is fount to copy the data into ano...
I see two ways to do it.
1. INDIRECT - the drawback is INDIRECT doesn't like closed workbooks. The files would need to be open to pull the data.
2. VBA - the best solution. Write a loop to open the workbooks, fetch the data, and return the values to the desired sheet.
Patrick2788 Thank you for your quick reply.
I tried to look at the VBA option, but i am at the beginning with the VBA and didn't figure it out how to do it.