NewToVBA123
New Member
- Joined
- Jul 9, 2018
- Messages
- 1
Hi all,
I am looking for a macro that will open multiple excel files in one folder location (to be input by the user) and extract only the tab named "Output" into a master file (which will be the workbook with the macro). Ideally, the "output" tabs would be renamed to the source file name and the links to the source files would be broken. Any thoughts?
I am looking for a macro that will open multiple excel files in one folder location (to be input by the user) and extract only the tab named "Output" into a master file (which will be the workbook with the macro). Ideally, the "output" tabs would be renamed to the source file name and the links to the source files would be broken. Any thoughts?
