The issue I have is, I have 9 Excel Files that shared with multiple users. All of these workbook and sheets fully protected. Each workbook has 30 sheets and conditional formatting. I have a master file that exactly identical to these sheet. [ basically this master file has 30 sheets with the same formatting]. How could I combine all these 9 file to my Master File/ Consolidated File? [All the Sheet 1 information (from the non consolidated files) need to go to Sheet 1 in the consolidated file.] Appreciate your help
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Consolidate Excel File
- Thread starter RX1985
- Start date
Similar threads
- Solved
- Question
