jjmartinson
New Member
- Joined
- Feb 27, 2008
- Messages
- 15
Hey everyone, I have a workbook set-up with multiple tabs with data in the same layout. I have put together a master page with multiple drop downs for users to generate various scenarios. Due to the multiple drop downs, I have coded nested if statements in the cells that are to populate data. The problem that I have ran into is that I would try to link the initial drop down to a tab. Due to the number of tabs (7) and the number of drop downs (5), I cannot make nested if statements.
Would you all know how I could link a drop down to a tab so that the remained of the drop down options are tied only to the selected tab?
Thanks for looking.
Would you all know how I could link a drop down to a tab so that the remained of the drop down options are tied only to the selected tab?
Thanks for looking.