How to filter rows with same column data and print result

**srfoot** · 09-28-2013, 12:56 AM

I have an excel spreadsheet example attached. I want to filter all rows in my full spreadsheet which have "OA" under Group code column and then be able to print these to their own spreadsheet. This way I don't have to scroll through thousands of rows to find each one individually.

How do I accomplish this?

Thank you for your help.

**ARGK** · 09-28-2013, 05:50 AM

Hi
Can you not just do a basic filter to display those rows with OA in a particular column?
Or you can use the Advanced Filter function - follow this link:
http://www.contextures.com/xladvfilt...l#createfilter
Tony

**:) Sixthsense :)** · 09-28-2013, 05:58 AM

But ensure that there should not be any blank line in your data. Because blank line stops the filter range.

**srfoot** · 09-28-2013, 02:03 PM

Thank you very much for your help. I appreciate it.

It worked.

I was able to figure out how to do a filter and have a report of only the category that I wanted.

Very nice of you all to help!