Anyone good with Excel?

[flipnkraut]

I know someone out there has a desk job dealing with spreadsheets and data all day, where you at?

Ok so here's the deal, I need some help figuring out what formula I could use to organize data in this spreadsheet.

I have one sheet with a bunch of data, one of the columns (lets say column B) has different Categories. IE, Stage 1, Stage 2, Stage 3.
Now I have 3 other sheets for each of the different categories.

What I want to do, is have some sort of method of being able to add data to the "Master" sheet, and when the category in Column B is filled it, it Automatically adds the data from the row to the respective sheet.
So kinda looks like this

Master Sheet
        A              B
1| thing 1    Stage 2
2| thing 2    Stage 1
3| thing 3    Stage 3
4| thing 4    Stage 1

So the Sheet for Stage 1 will contain
        A
1| thing 2
2| thing 4

 

[grizzlyboy]

Sounds like you need to use VLookup.

 

[yeah]

http://www.excelforum.com...-in-different-cells.html

 

[flipnkraut]

I tried VLOOKUP and either I'm doing it wrong, or I need a different function.

With VLOOKUP, in the separate sheets, its only pulling the first item. I don't know how to make it pull the 2nd/3rd/etc instance.
In my example above my sheet for Stage 1 using VLOOKUP would be
A
1| thing 2
2| thing 2

VLOOKUP appears to only be good for pulling a single instance of something.

 

[s0lefunk]

If you just want easily display all the rows that contain a certain entry within a column (ex. show only rows that contain Stage 1) then the Auto Filter will be enough.


The Auto Filter in 2010 is much cleaner.  The Auto Filter has saved my $++ on my past 2 jobs. People think I'm some Excel genius. You only gotta click one button

Cant help you if you are dead set on having the data extracted to different sheets. I imagine it would require a crazy IF statement though..