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!

[Kaper]

An easy way to do it will be to use autofilter and copy filtered data into separate worksheets

Try registering macro while doing first filterring (choose rather complicated case for this) and use recorded macro as a starting point.