I have a list box in A43. they choose “NU” “NT”or “CA” at the beginning of each row
an ex of one row:
In cells h43:k43, the user will place an “x”.
Only those boxes (h43:k43) with an x are totalled.
If they choose A43 (NU), then the values in h43=20,i43=25,j43=30,k43=40. The total will be in L43
If they choose A43(NT), then the values change in h43=12,i43=17,j43=22,k43=28
If they choose A43(CA), then the values change in h43=10,i43=14,j43=17,k43=20
Thanks for any help