Display Sheet when Data is in a Cell

[aggiemarine07]

Howdy!

I have an interesting excel question for yall. I searched google and couldnt find the answer (maybe I was phrasing it wrong), but I was wondering is it possible have a sheet un-hide when data appears in certain cell or hide it when data isnt in a certain cell?

Heres an example. I currently have a workbook with multiple tabs on it showing data for people within those groups. It is broken out as follows:
Tab1 (header sheet) - contains each group name in four different cells (cells A1,A2,A3,A4)
Tab2 (Group1) - contains a bunch of personal information about its members
Tab3 (Group2) - contains a bunch of personal information about its members
Tab4 (Group3) - contains a bunch of personal information about its members
Tab5 (Group4) - contains a bunch of personal information about its members

What I would like to do is use some sort of VBA/Macro that hides tab4 when we only have three groups or hides tabs 4 and 5 if only 2 groups. I would like to do this whenever I enter the group name in tab1 since they change every month or so. Is that possible? Thanks for all yalls help in advance!

 

[storm8]

this does the trick

If Sheets(1).Cells(1, 1).Value <> "Group2" Then Sheets(2).Visible = False

it can be within Workshhet_change event to called automatically

 

[aggiemarine07]

this does the trick

If Sheets(1).Cells(1, 1).Value <> "Group2" Then Sheets(2).Visible = False

it can be within Workshhet_change event to called automatically

Awesome, I'll give this a shot when i get into work tomorrow and let you know it works.

Just a quick question though, would this go in just Tab1 or do I need to put it in every tab?

 

[storm8]

Im not sure what are you trying to achieve. Can't you just filter the data on one sheet (by tabs you refer to sheets, right?)
This code will go just to sheet 1 and it hides the sheet from user.

 

[aggiemarine07]

Im not sure what are you trying to achieve. Can't you just filter the data on one sheet (by tabs you refer to sheets, right?)
This code will go just to sheet 1 and it hides the sheet from user.

Yes, sheet = tab

I think the code you gave me will hide the sheet if a value registers in a certain cell (a1 for example) right?

 

[aggiemarine07]

Also, can you explain how the code works? thanks for all your help.

 

[aggiemarine07]

Also, can you explain how the code works? thanks for all your help.

I found this thread on here that fit the bill perfectly. Thanks again for your help!
http://www.mrexcel.com/forum/excel-...o-hide-unhide-worksheet-based-cell-value.html