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...
Since all Testing files have the same structure and are in the same folder, I'd combine all of them, with some transformation, by Power Query into one table in main file and lookup this table for data required.