I set up a list to automatically plug in city names when i typed the first
few letter. However, now it does it for every sheet, new or old and I don't
need it to. I can't remember the name of the function and have scoured help
(local and on-line) trying to find the feature - no luck. Can anyone tell me
the name and how to turn it off for other worksheets.

Many thanks,
--
TONY