How to split data into multiple sheets based on column in excel

  • 0
  • 2295
How to split data into multiple sheets based on column in excel © How to split data into multiple sheets based on column in excel

Sometimes we need to split excel sheet based on column data. Here is an easy way using VBA code:


  1. Open Excel File and then open Visual Basic for Application by pressing ALT+F11 Key.
  2. Now go to insert menu and open Module.