Hi ,

Need a help to prepare macro.

I have excel which contains five sheets.

Details 1, Details 2, Details 3, Details 4 , Details 5 . With one excel I want to create multiple excels which contains two sheets and these sheets which save in particular folder .

Excel 1 – Details 1 and details 2
Excel 2 – Details 1 and details 3 . etc

Thank you…