Any one has an idea in how to create four files from one excel file with multiple sheets. The four files select different sheets from the one file. I need to automate this process. Please note I am new to VBA and struggling to deal with it.