Separate Tables into Sheets based on a Column

There are times when we need to filter and separate the table into sheets based on columns like region or departments.

Open the sheet that needs to be splitted.
Press Alt + F11 so as to open the VBA Windows.
Copy the code from below download link and paste it in the VBA Window.
Now, in Excel Click - View - Macros
Select Macro named "Split"
Input Box asking for column on basis of which the sheets are to be split is asked. Select the column of the Region or Department on basis of which column is to be split.
Press Okay.

Download VBA Code Split Columns