i have a combo box which i have already linked it up to a range of cell's on
another sheet... this is a combo box with state's... how do i insert a
function/ formula so when a state is chosen the result's automatically
populate another cell...

trey