M-TechRidge Blog

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

Change Language:

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.