Hi, I am try to add to a code that I already have in my workbook (see below).
I have multiple sheets in a workbook and I am using data validation drop lists to allow the user to select criteria to open the correct worksheet where the required information is stored. The code below does this for me. I want to add code once the appropriate sheet is visible, where certain columns and rows within that spreadsheet are highlighted (it is a large worksheet with multiple rows/ columns). My thought would be that all rows and columns are hidden (except header rows) and have a code to unhide rows and columns that pertain to the selection. For example, for list1 = "Choice1" And list2 = "ChoiceA" And list3 = "Item1" Then Sheets("Sheet1").Visible = True, maybe these selections I would want to unhide columns D through R and rows 3 - 80. The user can print out that information as needed. Then the rows/ columns need to be hidden again in preparation for the next selection. For example, ElseIf list1 = "Choice2" And list2 = "ChoiceB" And list3 = "Item2" Then Sheets("Sheet1").Visible = True, maybe columns Q thro T and rows 81 thru 100 need to be visible.
Any suggestions? Thanks