i want to create a separate files of branch with all sheet

  • I can get you all the workbooks into a temp folder.

    Hopefully somebody can see what is wrong with my email part,

    as soon as the code runs through the email part, vNum becomes empty and just goes to end sub

    You are one step closer though.

  • It would be best to have the email list in the master workbook.

    I would suggest the code needs to create a temporary workbook and email that.then delete it.

    Repeated for each branch

  • This will create the workbooks with variable number of worksheets.

    Keep the "Rough.xlsm" workbook in a separate folder, then when running the code it will place the new workbooks in that folder.