I need to extract select information from one workbook into another workbook
if the contents of one cell matches 1 of 4 numbers. It does not need to be in
the same order (col2 comes before col1 in the destination wkbk) so a simple
copy and paste is not the best answer.

wkbk1
col 1 col 2 col3 col4 col5 col6
col7 etc......
empid dept# ann sal. hire date title address name
123 535 22000 1/2/90 txt
122 726 30000 12/16/09 txt
178 513 25000 2/10/02 txt
552 810 42000 6/7/08 txt

Destination wkbk
name doh dept# ann sal

I only need it copied over if the dept# is equal to 513,535,540, or 560 and
only certain columns.

Any suggestions would be greatly appreciated.