Hi Austen,
For your HelpInfo sheet, I'd sugget you just get rid of the hidden sheet and hardcode your comments. This will add some additional flexibility rather than pointing to a specific cell. This looks better and is more decipherable (imho):
Option Explicit
Public Sub Setup_Sheets()
MsgBox "To use this program correctly there are a few things to know:" & _
vbCrLf & "(1) You have to have both sheets sorted." & vbCrLf & _
"(2) The raw data sheet is Sheet1. The master sheet is Sheet2. " & _
"The discrepancy sheet is Sheet3. All columns on Sheet1 and " & _
"Sheet2 must be the same and in the same place." & vbCrLf & _
"(3) When the macro runs if there are any discrepancies found " & _
"in ANY cell the entire line of Sheet1 is written to Sheet3. " & _
"If the data in Sheet1 is new the whole line is written to Sheet3.", _
vbInformation, "Help: Setup Sheets"
End Sub
Public Sub Running_Macro()
MsgBox "To run the macro do the following:" & vbCrLf & vbCrLf & _
" Go to Tools," & vbCrLf & " then to Macro," & vbCrLf & _
" then to Macros." & vbCrLf & vbCrLf & "A pop up box will appear. " & _
"Select " & Chr$(34) & "One on One" & Chr$(34) & " and click run. " & _
"The program will match the two files." & vbCrLf & _
"Depending on how large the file is it may take a couple of minutes.", _
vbInformation, "Help: Running Macro"
End Sub
Public Sub Disc_Sheet_Info()
MsgBox "Once the program has run if there are any discrepancies, " & _
vbCrLf & "the Discrepancy Report will be written on Sheet3. Any totally" & _
vbCrLf & "new line will be highlighted in light red and any row that has" & _
vbCrLf & "ANY change is highlighted in green.", _
vbInformation, "Help: Discrepancy Sheet Info"
End Sub
And where are the SSN?