Sorry if my reply's aren't formatted properly, I'm new to this website.
So I have got to this stage, from sheet 1 a cell will be given a value of Category 1, Category 2 or Category 3.
From that you press this command button which takes you to the next sheet and depending on the category will only show you the rows that are applicable, I keep getting an error with what I am currently using.
Sub Button15_Click()
If (Sheet1.Cells(6, 3) <> "") And (Sheet1.Cells(10, 3) <> "") And (Sheet1.Cells(11, 3) <> "") And (Sheet1.Cells(12, 3) <> "") And (Sheet1.Cells(13, 3) <> "") And (Sheet1.Cells(14, 3) <> "") Then
If (Sheet1.Cells(18, 3) = "CATEGORY 1") Then
MsgBox "Your Project has been classed as Category 1 and will now follow the appropriate process.", vbOKOnly, "Attention"
Sheet4.Rows("11:16,21:24,28:42").EntireRow.Hidden = True
Sheet4.Activate
ElseIf (Sheet1.Cells(18, 3) = "CATEGORY 2") Then
MsgBox "Your Project has been classed as Category 2 and will now follow the appropriate process.", vbOKOnly, "Attention"
Sheet4.Activate
ElseIf (Sheet1.Cells(18, 3) = "CATEGORY 3") Then
MsgBox "Your Project has been classed as Category 3 and will now follow the appropriate process.", vbOKOnly, "Attention"
Sheet4.Activate
ElseIf (Sheet1.Cells(18, 3) = "USE PORTAL TO COMPLETE") Then
MsgBox "too large for AMPS, Please use Portal.", vbOKOnly, "Error"
Else
MsgBox "Please populate all fields to progress.", vbOKOnly, "Error"
End If
Else
MsgBox "Please populate all fields to progress.", vbOKOnly, "Error"
End If
End Sub
It gets an error in the line trying to hide the rows