Hi,

You may use advanced filter and specify multiple criteria. You can also
specify which range of the worksheet would you want to extract data to.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dave H" wrote in message
...
Help,
I am trying to pull data from one workbook to another based upon a
condition
(in this case the State). However, the worksheet is sorted by a job code
and
not the State itself so VLookup doesn't seem to work. Below is a sample
for
reference:
I would like to copy all cells in a given row that contain data for AR for
example.
Thanks

Job City State Bd Due Date
Grand Opening

5 Talladega AL 11/6/2008
1/20/2009
3 Van Buren-Ft. Smith AR 11/13/2008
2/19/2008
4 Goodyear AZ 7/21/2008
10/31/2008