retrieving info from another sheet

  • Thread starter Thread starter Sheri
  • Start date Start date
S

Sheri

Thanks in advance for helping !! I am using Excel XP. I
have two different sheets of information. One sheet holds
an enormous list of data. I need to consolidate this
information on a separate sheet.

Here is a brief example:

068 Stamford CT 96.0 55.1
072 Stamford CT 67.3 34.2
082 Newark NJ 44.2 31.0
071 Newark NJ 30.1 42.9
100 Elizabeth NJ 72.5 53.8

Column B holds the city names. I need to pull all of the
data for each city and put it on another sheet. If I
request Stamford CT I would need all the data for both of
the lines with Stamford as the city.

Is there a way to do this??
 
Sheri,

There are two ways to do what you want that are native to Excel:
filtering and pivot tables. Either will give you the data for just
one city - and the specifics thereof - but how they are used, their
pros, and their cons differ. If you use a pivot table, when you
'drill down' on a city, you can automatically generate a separate
sheet with all that city's data if you still want a separate sheet.

HTH,
Bernie
MS Excel MVP
 
Back
Top