Hide & Unhide Multiple Sheets based on different cell values

Hello,

I have a workbook with 6 sheets in total that look like forms we can print out. For the most part, I just need to use 3 of the sheets (Each with 25 lines of data). In the event I fill up all 25 lines, I want the corresponding sheet 2 to unhide so the user can start filling up that sheet. Since I already have another Worksheet_change in each sheet, I was hoping I could have some kind of data worksheet that would do all the counting for each worksheet, and based on the values in different cells, that code would auto hide and unhide the worksheets that those values correspond to.

So, say I have worksheets:

Printers
Printers2
Toners
Toners2
Computers
Computers2

The values in worksheet "Data," cell B2 counts the rows of data in worksheet "Printers" and tells me how many lines of data have been entered. If the Number is >=25, then worksheet "Printers2" is visible
Also, if the the values in worksheet "Data," cell B3 counts the rows of data in worksheets "Toners" and the value is >=25, then it would unhide "worksheet "Toners2."
etc.

I found something like this, but it only works for 1 value and hide/unhiding 1 sheet.

Please Login or Register  to view this content.

If someone can point me in the right direction, I could use some help.