Multiple Calculations from different pages - macro

I'm working on this excel tool that I would like to make as user-friendly as possible. It would act like a survey almost where the user would choose responses or input values for specific questions and then on other worksheets it would have the actual calculation and math.

I see that if one were to add a value onto worksheet 1 and which would be a variable that is essential to a calculation on worksheet 2 it does not run automatically. I was wondering if macros would help solve this?

Q2). if there is a combo box w text values that also needs to have a calculation on another page, can i just do an IF statement on worksheet 2 with combo boxes?

Q3). I can't find any more information about the Commercial Services forum other than the costs. How does the value of the points work? Just one point per thread? I am new to using Macros but I would really like to learn how to use them and think they would benefit my tool greatly.

Thanks!

Originally Posted by FDibbins

what do you mean by that? If you have a formula, unless calc is set to manual, it will calc every time anything is entered that will affect it.

Q2). We would have to see what you are working with to be able to offer suggestions

Q3). 1 point = $1. So look at it this way. If you offer 1 point for a thread, you are offering $1 to whoever agrees to help you on that thread. If you think that help is only worth $1, then thats fine. If you think that help is worth more, then offer more.

Depending on what you want, and how long it takes (and yes I know, its always hard to determine that, even when you know what you are doing), you could be offering somebody $1 for 2? hours of work

Awesome thank you. I will try the smaller stuff and then if things get too complicated might have to resort to the commercial offerings