EXCEL how to work a table according to the different conditions of work into two tables

A zjh 161012 in 2500 2008-9-4 Kong
lsp 161013 C 1000 2008-2-22 2008-11-7 8 months and 16 days off
a worksheet in a number of such records, how In the post and the posts were not exported to a different worksheet in the other two.Thank you advice!!!

In the “on-the-job “” Off-the-job “that the election out above data screening ? ? automatic filter, and then choose” Kong “with” off-the-job “, copy it to another worksheet on the line, you can direct the work of the table in the first paragraph of all references to the new Two of the table, and then the new table were automatically off-the-job screening, in the post.