advanced filtering

[shane.granger]

Hello all.
I am looking for a way to populate a seperate sheet using values listed on a master sheet.
For example; on "Master" there are several columns containing data one of whick is <Status>.
What I am trying to accomplish is to have the "Open" Sheet look at the "Master" Sheet and search for the value "Open" and have it automatically bring in the values listed.
In the attached Workbook, "Master", "AAAA", "BBBB", "CCCC" and "DDDD" are currently set up. "Open" has the end result I am looking for.
Is there a way to get this done?
Thanks.

[jrussell]

I would use pivot tables for this. You'd set up several different pivot tables (Open, A, B, C, etc) all based on the same table or named range. Use filters on particular fields so that only the correct tickets show up. Then you could update the values (Notes or whatever) in the table/named range, refresh the pivot tables, and all of your sheets will have the correct info. It's faster and more accurate than manually copying data. Have a look at the attached file.

[shane.granger]

jrussel
thanks very much. that's exactly what i am looking for.
much appreciated.
shane