formula to Info from one wkbk meeting certain criteria copied into

[bkinman]

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.

 

[bkinman]

Sorry, first post and I posted to the wrong group. I was in Excel I swear!

 

[Tom [Pepper] Willett]

You need to post in an Excel newsgroup..this is for FrontPage.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
: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.