I'm attempting to write a macro that will display results based on the entry in a few fields. I've programmed the workbook to hide pertinent rows upon opening the file. I want it to then unhide rows based on the value of cell B2, which is a drop-down menu with 15 options.
If option "A" is selected, I want it to unhide rows 7 & 8
If option "B" is selected, I want it to unhide rows 9 & 10
. . . and so forth.
I also want to make sure that as the value of cell B2 is changed, only the corresponding rows are displayed (so previously unhidden rows need to be rebidden).
I can't seem to figure out how to put more than one if/else statement in succession to make this happen!
All help is much appreciated.