Hello all,
Here is one that has been stumping me. In the example excel sheet attached i have two tabs (they are in two tabs because this is a sample and the real workbook is large and complicated), one that has data and one that has a set of equations.
In the data tab, Row 1 has headers 10, 9, 8, 7,.... These numbers are calculated by the output 1 on the equation tab. In the data tab, Row 2 has the the two headers YES and NO. This is determined by output two.
What i want to do is create a macro so that when Output 1 and Output 2 are determined it adds a number to the corresponding field.
i.e. If output one is 8 and output two is No, all i would have to do is run the macro and it changes the number in the data tab under 8 and No from 91 to 92.
The formatting of the tabs can change but the data and equations tabs really will have to stay the same (therefore, you can't move the data to the equations and vice versa)
Please let me know if this is possible.
Thanks.
Bookmarks