Split sheet into separate workbooks using VBA on Excel 365

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    Hi there,

    Thank you so much for this post. It is really very helpful.

    I have situation that requires me to split salary data per department so that each manager will receive a workbook for their team only. I do not mail these out to managers, I simply safe it in their respective folder on the server.

    I use this code, but this code does not split the worksheet into separate files. Can you please help me to modify this code so that it will create separate workbooks for me in the same directory as the master sheet?

  • Possibly...

    If I've been helpful, let me know. If I haven't, let me know that too.