VBA

I have an excel sheet that calulates values by using/extracting data from other sheets. I want to find a way to make a window that pops up of sorts and for me to change one component that would adjust all the other values. Is that feasible? Would I use Visual Basic for that? Where would I start?

Like say the excel sheets uses a formula where workload depends on cost of labor and budget (among other things); I’d like to be able to change the cost of labor amount and have excel project how the other variables would change.

Is this possible?

By: Hal

Leave a Reply

Your email address will not be published. Required fields are marked *