Jul 10 2021 10:20 PM
I have a few cells where the user inputs a value, which is then used in formulas. Like variables.
Is there a way to input the same values in different places (worksheets)? (If possible without VBA).
See the example attached. A table with formulas in "Calc" that refer to 2 variables in "Var".
In both sheets "Report 1" and "Report 2" I would like to let the user input values for the same variables a and b (yellow cells).
Jul 11 2021 11:16 AM
Solution@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?
Jul 11 2021 11:40 PM
Jul 11 2021 11:16 AM
Solution@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?