Filter Static List
 

Hello Everybody

I have a (3 column) static list in Sheet 2 and need to filter that list by a
selected cell on sheet 1. I would like to set it up so that when I type a
list name in the selected cell in sheet 1 that it filters the list in sheet 2
in place. I do not want to copy the data into another sheet, I want to
filter the actual list. Sorry If I sound a lttle vague, I am new to this.

thanks