pulling data from one workbook to another based on a condition

D

Dave H

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
 
A

Ashish Mathur

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
 
D

Dylan @ UAFC

acctaully this sound like the perfect scenrio for vlookup
infact if you have a unqiue text or value that can sorted acending
you are really in the money.
Start by copy and pasting the data into another sheet on the workbook
I find vlookup does not to well for file to file transfer of data
if you need file to file transfer of data just =a1
or exact template of the data the carred over
vlookup is should work great
wright back the vlookup formula you are using and
I could possible understand the delem better
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link to one worksheet to another worksheet in same workbook 0
Pasting Data from One Workbook to Another 0
Data selection from one worksheet into a second worksheet. 1
Transfer data from a cell to another workbook if certain criteria 14
Copy data from one worksheet to another 5
Copying data from one workbook to another dependent on user select 1
automatically import data from a cell in oneworkbook to another workbook 3
copy data from 1 worksheet to another based on a condition 9

Top