VBA Code to Separate Data from Columns into New Sheets

[leafsfreak12]

Hi all,

I' have been trying to create a script that will separate data into new sheets from a master list. Unfortunately, I am still quite new to macros and can't figure out how to do this.

What I am looking to do separate the master data into new sheets based on data from different columns. The columns I would need the data separated by are K, L, M, N. Columns L, & N I would just need the data bucketed into "No" and all other unique numbers in another bucket.

For example I would need the data separated into...

EN, NO, 1, REPEAT
EN, GST, 3, NO
FR, NO, 2, NO
etc. until all possible outcomes have been created in a new sheet.

This is a very manual copy and pasting process, and it would be greatly appreciated if someone could help me out!