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