i have a drop down list in column A3 with a few items . i wanna enter a value in column a5 and then on a different sheet i would like the value i added to be added to the correct item that was selected in the drop down list . So i select bananas from list. i then enter a value in a5 and it must then update a stock sheet i have created .. Any ideas on how to do this .?
