I am using Excel Ver2003.
I have several tabs of data tracking customer complaints by year (2006,
2007, etc.). Each tab contains about 20 columns of the complaint specifics.
Each tab may contain up to 100 complaints. Some of the complaints are open,
some are closed. I have been tasked with generating an "Executive Summary"
showing all open complaints and their status. I would like to be able to
select a department and have all open complaints from that specific
department populate the summary tab.
On the Excutive Summary tab I created a pulldown list for the departments.
Using the pulldown value I can get the Hlookup to find and transfer the data
from the first occurrence of the departments complaints from one tab, but it
doesn't transfer the rest.

Sorry for the long winded description. I would be open to trying other
methods if they would be better suited.

Perp