Unhiding and Hiding Worksheets based on a range of values

**menor59** · 10-02-2008, 05:11 PM

Hello Folks.

ive got a workbook, that has a worksheet called Query that If you type a number in a Given cell in this case H2. It returns the Sheet names (that are hidden ATM) on the same sheet in cells E15-E51. Sheet names are in mmm dd,yyyy format. What i would like to see happen is that if any of sheet names appears anywhere in E15-E51, I want the workbook to show those sheets and those sheets. If E15-E51 dosent have anything dont show sheets. FYI 2 Sheets Must be Exempt from the Rule. Sheets named BLANK, Query. make sence?? Please see my attachments below. Thank you so much.

**mdbct** · 10-02-2008, 11:57 PM

Right click on the Query tab and choose View Code. Paste the following:

Please Login or Register  to view this content.

The code assumes that all data returned in the E15:E51 range will have a corresponding worksheet.

**menor59** · 10-03-2008, 12:33 AM

For clarification E15:E51 actually has a reference

Cell E15:E51 has =H1 ~ =H36

And H15 has =IF(ISNA(MATCH(H$2&"_"&ROW(W1),Y$1:Y$550,0)),"",INDEX(X$1:X$550,MATCH(H$2&"_"&ROW(W1),Y$1:Y$550,0)))

which is actually the tabs name...which is shown in the Attachment