Drop down box
 

Using Excel 2003: I need to create a drop down box that links to a vlookup
table (so that data is valid when looking up). My issue is that data will be
entered frequently but the need to select from the drop down box is limited.
I want to be able to select from the drop down box once and have the
remaining cells in the column be updated by what I select. Only once I
select data again from the drop down box, would the cells below change.