Hi

Excel 2007
I have 2 sheets, sheet 1 has a list of names, sheet 2 has a list with
multiple entries of the same names.
Is there a way to ensure that only names contained in Sheet 1 can be entered
in sheet 2?

Thanks

Brian