use datavalidationlist

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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