1 You know where the data from that sheet should go, so it shouldn't be hard to work out.
With Worksheets("JobIntvwData")
wsForm.Range("N46") = .Range("A2").Value ' .ReqRcvd
wsForm.Range("K7") = .Range("B2").Value ' ReqNo
' ...rest of fields
End With
2 The If Then's shouldn't be in the userform code, they belong in the code for filling out the form.
Here's an example which goes in the sub FillForm.
wsForm.Range("N29") = IIf(rngCand.Offset(, 2).Value = "EMPLOYEE", "*****", rngCand.Offset(, 11).Value)
Bookmarks