Need Help with VBA for hiding rows and columns based on value from multiple drop downs

[NWPhotoExplorer]

I am brand new with VBA code but from my google searches, this seems like what I should be using. I’m hoping someone can help me made this worksheet.

I’m trying to design a sheet that will keep track and display the number of ports on my circuit. The rules are I can split each port 3 times. So I am going to have 3 columns. The splitters are in multiples of 2. 2,4,8,16,32 and 64 ports. The only limitation is that I cannot have more than 128 ports total. So I need to keep track of my splits and make sure they don’t add up to more than 128. I’m hoping to be able to calculate this as well.

I would like to select the number of ports on the splitter and then unhide those rows. Then move to the 2nd stage splitter and enter the size and unhide those ports for that port on the first stage splitter. This is where I need help writing some VBA code. I have no idea what to google on this.

I’m hoping this makes sense on what I’m trying to accomplish.

Thanks in advance.