Excel 2007 dynamic values sheet 1 on click

Good afternoon. I received help from this forum about 6 months ago on a difficult excel sheet and I'm hoping to get help again. I did some google searches, some searches on this forum and tried to swap some code based on the results but I'm still at square 1. Thank you in advance.

Workbook is attached. You will notice some yellow highlighted fields (sheet 1) that I would like for the values to be dynamically loaded (pulled from sheet 2) on the workbook being opened, then the results to change based on the user clicking on different options on sheet 1. The sheet 1 and sheet 2 values in fields that are *not* highlighted in yellow will be permanent, or manually changed.

There are some 'Totals' forumlas that I think can remain permanent. But that is assuming if the values change on sheet1, the permanent 'Total' formulas will recalculate on the fly.

I have a text box in the workbook with more explaination, but please if more is needed beyond what is mentioned there let me know.

Unless you have an absolute need for a macro, I'd avoid it in this case for two reasons:
1) the user will have to enable the macro or it won't work
2) the scenario you've suggested is prone to trouble since if the user accidentally double clicks, the macro won't run until the cell is merely selected instead of being in edit mode, so you'd need another procedure to handle that.

I'd suggest compacting your sheet by using dropdowns and formulas. See attached.

Originally Posted by tlafferty

Unless you have an absolute need for a macro, I'd avoid it in this case for two reasons:
1) the user will have to enable the macro or it won't work
2) the scenario you've suggested is prone to trouble since if the user accidentally double clicks, the macro won't run until the cell is merely selected instead of being in edit mode, so you'd need another procedure to handle that.

I'd suggest compacting your sheet by using dropdowns and formulas. See attached.

I didn't even know this was possible. The formula for average value is insane. Thank you for the quick response and expertise.