One possible way
http://www.contextures.com/xlDataVal03.html
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
"darkbearpooh1" <(E-Mail Removed)>
wrote in message
news:(E-Mail Removed)...
>
> how can i make a data validation list that will remove a name already
> used ? thanks
>
>
> --
> darkbearpooh1
> ------------------------------------------------------------------------
> darkbearpooh1's Profile:
> http://www.excelforum.com/member.php...o&userid=30640
> View this thread: http://www.excelforum.com/showthread...hreadid=518115
>