The pumps is a drop box with a list of pump 1 -4. I need to be able to have the cell next to the pump box change its value as with a selection.
Thanks for your help.




Pumps





pump 1 100
pump 2 200
pump 3 300
pump 4 400