My question is, is it possible to store data from different drop-downlist option?
The situation is like this: I have a drop-down list containing option: A-1, A-2, A-3, A-4, A-5. Once I change the option in drop down list. The content of that sheet will also be changed, and there will be a value sum store into cell G2.
i want to store G2 value in another sheet call: Summary in cell B3. For example, when the drop-down list option is "A-1", the value is 5. and store into B3, when drop down list change to "A-2", it will then store into B4, but the value in B3 remain unchanged. Is it possible to finish this with excel formula?