Macro to split data based on the value from specific column

[arnelgp]

there was no table, so i add one.
because on your original post there is a table.

there is a code in ThisWorkbook, Open event, copy that to your workbook.
there is a code in Module1 copy the whole module to your workbook.
create "job" sheet to your workbook.
and add a button and assigned a sub to it.