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...
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.
I'd do it in two parts. The first part presents you with an open dialog to select the files. The next part writes each open files' data to your sheet. Just need to know the cell addresses in each workbook and where to write the data in the destination file.