I am trying to run Anova single factor calculation for three different groups. I want to see how the anova values change when I edit the group values. Is there a way for excel to auto-update the anova calculation when I make changes to values? I tried searching online and found a Reddit post(https://www.reddit.com/r/excel/comments/4x9al9/is_there_a_way_to_make_an_anova_calculation/). They mention VBA macros as a possible solution but didn't elaborate. Can someone help write one for me or direct me to a site that can quickly show me how? Thanks!