I have created the following "IF" formula =IF('officer
data'!Z4="fse",'officer data'!A4) to pull employees that have a status of
"fse" from another worksheet in the same workbook. I only want to show the
rows that are "TRUE" and automatically hide rows that are "FALSE"