Microsoft Excel : How to Split the data according to column values to different sheets

  Prerequisite : Please download ASAP Utilities and Install it. 

Steps for installation  

After installing , you will be able to see ASAP Utilities as a add on . Please check the image down below.

Step 1 : Select the data & Go to ASAP Utilities --> Sheets -->  Split the selected range into multiple worksheets.