In J7 a user can enter any dollar value they like, if however if K7 = "total" then I need the cell contents of J7 to be replaced by the cell contents from J18. If K7 = "cap" then I need the cell contents of J7 to be replaced by the cell contents from E25. K7 is a drop down list with "total" and "cap" as the two choices. I need the script to run every time the selection is changed in K7.