...not as simple as I thought - or is it?
Posted by Stan Dubuque on January 31, 2002 12:31 PM
( simplified example )
I have a worksheet named "name/grade" with two columns of pertinent information, and "infinite" rows.
Column 1 is labeled "name", and column 2 is labeled "grade".
Grade value can be between 1 & 25
On a separate worksheet ( in the same workbook ) named Grade 1, I want a complete list of all names with grade level "1"
On a separate worksheet ( in the same workbook ) named Grade 2, I want a complete list of all names with grade level "1"
And, if possible ( not critical), I would like to see the contents of the summary pages updated whenever the "name/grade" worksheet is modified.
Can this be done?