Winterhawk
New Member
- Joined
- May 18, 2017
- Messages
- 1
Hello everyone,
My tast is to program something for a testing environment. The tester should enter a value and the program should be able to store the value inside a databank(in an extra sheet). A mean is calculated from on the newly entered value plus the old ones. The calculation should be carried out once again when new values are entered. There should be a rewind function that can remove the entered value from the databank in case the tester entered a wrong value.
Any suggestions how I should go about the problem? I wish to execute this with Excel VBA. with one cell for data input and one cell for mean value output. I am very new to VBA and have been learning it for the past few days. I only hope that the process can be quickened if I receive some help here.
Any tips will be welcome. Thanks in advance
My tast is to program something for a testing environment. The tester should enter a value and the program should be able to store the value inside a databank(in an extra sheet). A mean is calculated from on the newly entered value plus the old ones. The calculation should be carried out once again when new values are entered. There should be a rewind function that can remove the entered value from the databank in case the tester entered a wrong value.
Any suggestions how I should go about the problem? I wish to execute this with Excel VBA. with one cell for data input and one cell for mean value output. I am very new to VBA and have been learning it for the past few days. I only hope that the process can be quickened if I receive some help here.
Any tips will be welcome. Thanks in advance
