You would need to use VBA and change the range every time a cell changes as
far as I can see.

That OK?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steph" wrote in message
...
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.