Help Making a Calculator

[Baiano42]

Hey everyone,

Here's a spreadsheet I am working on: https://www.dropbox.com/s/xavhulqwi91xamh/Profitability Calculator.xlsx?dl=0. My goal is to make a calculator that is streamlined and aesthetically pleasing as I can. Right now, I have set it up to do the calculations for me, but I have hit a wall that I can't overcome on my own.

The Question: Is there a way to insert a combo box that when selecting between the three calculators I made, it will hide all rows and columns, except for the ones related to calculator selected?

Thanks!
Baiano42

 

[Joe4]

Cross-posted here: https://www.ozgrid.com/forum/forum/help-forums/excel-general/1197724-excel-help

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Baiano42]

Sorry Joe4, will note that for next time...

so as far as responses from the previous thread, here's what I got so far:
From: Logit
"Code:
Sub sbHidingUnHideRows() 'To Hide Rows 5 to 8 Rows("5:8").EntireRow.Hidden = True 'To UnHide Rows 22 to 25 Rows("5:8").EntireRow.Hidden = False End Sub

 

[Baiano42]

Now, as far as setting up the Combo Box, does anyone know where I can find a good step by step instruction on how to insert it into a cell? (I've never done it before and kinda don't know how to do it yet...)
Also, for the code above, could someone walk me through it so I can understand what it means, please? And lastly, would it be something where I could set the drop-down options to "...", "INN", "OON", and "Secondary" such that the "..." would hide all unused cells, "INN" only does the INN calculator, OON the OON, etc.? Thanks a ton for all the help!