What I am trying to do is set up a shipping chart for 600+ companys designated to different zones. I'd like to have a list of these companys (hidden) with a specific fill color for that zone. Above on my production log, i'd like to be able to begin typing the name and autofill the rest of the name and fill color. This would help speed up my shipment scheduling.

Thanks for any help or advise!

Best Regards,
Eric