D3allamerican07
Board Regular
- Joined
- Jul 22, 2015
- Messages
- 101
So I have 4 sheets, an Index and 3 error sheets.
The index has each error type in row 1
Row 2 has Sheet 1 errors
Row 3 has Sheet 2 errors
Row 4 has Sheet 3 errors
I need a code to look at the error type in row 1, column B, C, or D, and hide certain rows on the relevant sheet when the hyperlinked number is clicked.
Index:
ColumnA---------ColumnB--------ColumnC----------ColumnD
--------------------Error1------------Error2-------------Error3
Sheet1--------------12-----------------3--------------------5
Sheet2---------------1-----------------40--------------------2
Sheet3---------------0------------------0-------------------0
So when the user clicks the number 12, it activates Sheet1 and hides all rows with Error 2 and 3.
If the user clicks the 40, it activates Sheet2 and hides all rows with Error 1 and 3.
The index has each error type in row 1
Row 2 has Sheet 1 errors
Row 3 has Sheet 2 errors
Row 4 has Sheet 3 errors
I need a code to look at the error type in row 1, column B, C, or D, and hide certain rows on the relevant sheet when the hyperlinked number is clicked.
Index:
ColumnA---------ColumnB--------ColumnC----------ColumnD
--------------------Error1------------Error2-------------Error3
Sheet1--------------12-----------------3--------------------5
Sheet2---------------1-----------------40--------------------2
Sheet3---------------0------------------0-------------------0
So when the user clicks the number 12, it activates Sheet1 and hides all rows with Error 2 and 3.
If the user clicks the 40, it activates Sheet2 and hides all rows with Error 1 and 3.