How to pull information, and organize them.

[Smashingdude]

Hey everyone,

This is my first post, so Hi!

I have a fair understanding of using excel 2007, mostly related to data input and charting. However, I need to go a bit further this time, and I have no clue how to do so.

I have data which is all over the place, and I want it to be organize in a better place. For instance, I have a column with 'Location', which lists the various US states with some programs. I want to pull only those rows with New York for example, and arrange them in a separate table. Or I have a column with "Housing and the variables are "YES" and "NO". I want to pull only those rows with "YES" in the "Housing column" and arrange them in a separate table. By table I mean all the other data from other columns should also be pulled.

Let me make an example to make it clear:

Program Location Housing Salary
A NY YES 20k
B MD YES 30k
C NY YES 20k
D CT NO 20k


I want some code or way to pull information from this table that list all entries of "NY". For instance, the code should give me this:

Program Location Housing Salary
A NY YES 20k
C NY YES 20k


Or if I want only with "No" in "Housing", the code should give me this:

Program Location Housing Salary
D CT NO 20k


There are tons of data, and many more columns, so naturally its hard to do it individually. Anything that can help me in pulling and organizing the data as I have mentioned would be great.

Thanks everyone!

[Smashingdude]

The spacing didnt appear as I wanted to. But I hope you all understand. The "Program Location Housing Salary" are separate columns, and the "D CT NO 20k" are the rows beneath them.

[Pepe Le Mokko]

Try using a filter

[bmouse]

Sounds like you could use an autofilter or create a pivot table to select & sort certain data based on criteria