Hi All,
I am currently trying to create a macro that will loop through different files in the same folder and copy a tab containing the word "vacancies" into the current (active) workbook.
I'd like the macro to not require all files to be opened, if possible. Thanks in advance!
I am currently trying to create a macro that will loop through different files in the same folder and copy a tab containing the word "vacancies" into the current (active) workbook.
I'd like the macro to not require all files to be opened, if possible. Thanks in advance!