Sometimes we need to split excel sheet based on column data. Here is an easy way using VBA code:
- Open Excel File and then open Visual Basic for Application by pressing ALT+F11 Key.
- Now go to insert menu and open Module.
Sometimes we need to split excel sheet based on column data. Here is an easy way using VBA code: