Go to http://www.contextures.com/excelfiles.html#Filter
and search for "Product List by Category".


--
If you find this post helpful pl. choose "Yes"...


"kathryn462" wrote:

That is not exactly what I am looking for. Basically I have a list of
employees with information about them and a drop down list to retain or
terminate. I need to automatically copy all of the information onto a
separate sheet for anyone who is selected as a term.