View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Art Art is offline
external usenet poster
 
Posts: 587
Default Auto fill with custom list

Is there a way to make a list of certain items, and use that as a auto fill
list? for example on a seperate sheet, when I start writing a word, it should
auto fill it? (I'm not talking about the custom list from the drag / fill
feature).
For example, I want to make, that when I start
writing for example, "milk" and milk is on the custom list that I created,
then when I type "mi" it should auto fill it with milk. and so on. I have a
long list. Please help.