I have created a validation drop down menu for specific options and I am now
trying to automatically populate different cells in this worksheet based on
the option chosen.