I need to first ask if these are two sheets in a single .xls file or if we're
talking about working with 2 sheets in 2 separate .xls files. Some of the
methods that might provide a solution would require that both workbooks
(separate .xls files) be open at the same time. That wouldn't be a
consideration if it is 2 sheets in the same file.
Offhand it sounds like you're probably going to be looking at using some
VLOOKUP() formulas an perhaps some variation of SUMPRODUCT() to get to the
information.

" wrote:

I am trying to link two Excel (2003) spread sheets so that I can pull
specific information from one and add it to the other. An example would be:
if I have a large list of companies in one spreadsheet and I would like to
pull out all the information on all companies with more than 20 employees.
This information would be displyed in the second sheet. Or in the second
sheet I only want to see the companies and their information if they are
located in a specific city. Please help or at least show me where to get
started. Thanks.