Seperating a worksheet into multiple files named according to a corresponding row?

[Shaaarrrp]

Hello all,
Relatively new to all this vba stuff and was hoping for some help:

I have a spreadsheet with 10 columns and hundreds of rows. The only columns that matter for the coding would be these

Column K: Area #
Column J: Job #

Is it possible to run a vba code which outputs a different excel spreadsheet file for every value in column k (area #)? In other words, if there were 10 different column K values within 30 total rows I would want 10 different files outputted corresponding to each different area #, all that contain every row which pertains to that area.

The only thing I would want column j for is to sort when outputted (in ascending job #). Not particularly important but would be helpful!

Thanks for any help!

[Shaaarrrp]

bump...this has to be possible right?

[Shaaarrrp]

Anywhere else yall could suggest I ask this?

[Shaaarrrp]

Bump....any assistance would be greatly apppreciated!!!!