Quote Originally Posted by Rick Rothstein View Post
Except for the position of the columns, it sounds like AutoFilter may produce the lists you want to see. You didn't tell us the version of Excel that you are working on, so we cannot give you specific directions on how to find it, but you would start by selecting the Agency Name column and then turn on AutoFilter. Look for it either in the Data menu item of XL2003 or the Data tab on later versions of Excel.
Hi Rick, Im using excel 2007. Auto filter wouldn't work because the drop down menu is part of a budget template and the list of data needs to be hidden. Thank you though for your willingness to help me. Take care.