Hi I'm trying to make a menu system within my excel file using a pull down menu that will fill certain cells with specific number values once a specific option is chosen. my skill with excel is basic and pull down menus are new to me. I've looked through several places in the forums but cant find what I'm looking for. it may be there i just haven't found it I have made a sample file to give you an idea of what I'm looking for. more info is found in the comments. if someone could help me figure this out I would be grateful


Blake Griffon sample.xlsx