image
Dinesh Thakali

Separate Worksheets into Separate WorkBooks

Once the sheet is separated into different worksheets (as given in example 2), many times we need to send different sheets to different people (vendors/branches/departments). For that follow the following:

  1. Use the code and procedure given in Point No. 2 before this procedure to separate the worksheets based on a column.
  2. Then open VBA Windows with Alt + F11 and paste the Code given below.
  3. Run the VBA Code from the View Macros with name Splitbook.
  4. Your sheets will be separated and saved in the same folder where your workbook was open. Enjoy working smartly.

Download the Code Here Split Books