If you're talking about a list of mixed data, like Col A is a mix of Class 1
and Class 2 items, then you might consider doing an autofilter (Data,
AutoFilter). This will allow you to select your criteria from down downs
and see only the records that match them.

--
Jim Rech
Excel MVP
"younathan" wrote in message
...
|
| Hey guys,
|
| I need some help...I have worksheet that currently holds data for 2
| different classes. What I plan to do is to have a combo box (2 items
| in the list) that allows me to switch between the data (i.e. from class
| I to Class II, all the Class I data is hidden and all the Class II data
| appears). Furthermore, the worksheet layout for each class is
| identical, this is why I want to add this feature, because it would be
| much more convienent for me to have a link to access either class
| through the combo box instead of having both Class listed next to each
| other.
|
| If there are any other suggestions, besides using a combo box, please
| let me know also.
|
| Thanks for the help in advanced!!
|
|
| --
| younathan
| ------------------------------------------------------------------------
| younathan's Profile:
http://www.excelforum.com/member.php...o&userid=15415
| View this thread: http://www.excelforum.com/showthread...hreadid=270212
|