View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
poloxstar[_9_] poloxstar[_9_] is offline
external usenet poster
 
Posts: 1
Default drop downlist that captures criteria from another sheet

Hi, I am need of assistance
I am trying to create a dropdown list based on a criteria from anothe
sheet.

Area 3
Dropdown list


Sheet2
Tech# Skillset
1 video
2 hsi
3 tele
4 hsi,tele
5 hsi,video

I also want it to validate, if they enter a tech that is not in th
list an error message occurs.
Any help we be deeply appreciate

--
Message posted from http://www.ExcelForum.com