Dynamic Parameter Update and Live Calculation in Excel Dashboard Using VBA

Hello everyone, I'm relatively new to in-depth Excel formula/VBA use. I am facing the following problem:
I have a 'cockpit' worksheet that allows the input of 3 parameters (assume A1, A2, A3) from which a value is calculated in A4. The calculation basis on which A4 is based is stored in a worksheet called 'Calculation'.
In another worksheet called 'Dashboard' (don't worry - it's the last one), the values A1, A2, A3 and also the output from A4 maintained in the cockpit are displayed by referring to the entries in the cockpit. This already works perfectly.

However, the requirement is now as follows:
The user should be able to enter the data in the cockpit initially and have it displayed in the dashboard by default, as is already the case. However, it should also be possible to adjust each of the parameters A1, A2 and A3 in the dashboard so that the output A4, which is also displayed in the dashboard, changes live.

Is this possible using VBA or VBA/Formula mix?

Regards
julius

Hi and welcome Julius.

Could upload a sample (desensitised) workbook so we can see the problem in context?

Probably a simple case of adding worksheet change events (VBA) that will switch the parameters on the 'other' sheet when you change them on the active sheet. But that's a pure guess based on the info provided and no sample workbook to look at.

BSB

Example Worksheet.xlsm

This is now very simplified. The dashboard looks identical to the cockpit.
In the practical file, however, the data in the dashboard is nicely prepared and should only be identical to the values from the cockpit at the beginning and the parameters can be changed as desired so that the output also changes dynamically.

Greetings