Forum Discussion
Input the same value (variable) in different places
bartvana , in case the expectation is that the multiple input entry cells can each contain their own values and only latest of them to be considered in calc, then i'm afraid VBA is the only way as far as i know. It can be done using the selection change event of the worksheets. I hope someone in the community should be able to help you with the code.
However, if the expectation is that at a time only one if the entry cells must be filled and that to be registered as final input (i.e. multiple entries not allowed together) then this can be managed easily using some IF or ISBLANK formulas. Example worksheet is attached.
Looking at the ques. it seems though that you're looking for simultaneous entry case and latest entry value to be considered. Is that so?
bartvana , in case the expectation is that the multiple input entry cells can each contain their own values and only latest of them to be considered in calc, then i'm afraid VBA is the only way as far as i know. It can be done using the selection change event of the worksheets. I hope someone in the community should be able to help you with the code.
However, if the expectation is that at a time only one if the entry cells must be filled and that to be registered as final input (i.e. multiple entries not allowed together) then this can be managed easily using some IF or ISBLANK formulas. Example worksheet is attached.
Looking at the ques. it seems though that you're looking for simultaneous entry case and latest entry value to be considered. Is that so?
- Yes, I'd like "linked" cells somehow, so that if you change one of the input cells, the others follow and vice versa. I suspected it would need VBA. Thanks for answering!
