Hi. In a simple worksheet (Sheet1) there is 2 columns:
Include Name
Y Bob
Y John
N Bill
Y Tom
N Mike

How can I create a named range that will have only the Names of the people
that have a Y in the first column? And will vary when I change the contents
in the "Include" column? Thanks in advance.