creating drop down box/menu in a cell

[Newatprogramming]

I am trying to find out if I can create a dropdown box/menu in a cell that I pick from that can fill the cell below (same column)

 

[Zathras]

Not sure what you are trying to do. You can use Data/Validation... to provide a drop-down in a cell. Then simply reference that cell directly. It is not necessary to have a second cell involved. (Unless there is more to it than you have stated.)

If you really want to, you can drop a combo box on the sheet from the Control Toolbox (From the menu: View/Toolbars/Control Toolbox) and set the ListFillRange and LinkedCell properties, but that is more work for what would appear to be the same result.

 

[Newatprogramming]

Thanks for the help. I figured out what I was trying to do. I wanted auto filters. Appreciate the help though!!