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"

You could apply a filter (Data, Filter, AutoFilter) and then have your filter
show everything that does not equal FALSE. (under custom)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kiley" wrote:

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"

That works but I was hoping that there was a formula to help do this because
I am using this workbook as a template and the employees may change. If I
appy the filter and change the employees, the new employees are not
automatically visible.

"Luke M" wrote:

You could apply a filter (Data, Filter, AutoFilter) and then have your filter
show everything that does not equal FALSE. (under custom)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kiley" wrote:

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"

There's no formula that will hide rows.

You'll either need a macro or teach the users to show the data and filter it
again.

(If you teach them, they'll be able to use filters in lots of workbooks!)

Kiley wrote:

That works but I was hoping that there was a formula to help do this because
I am using this workbook as a template and the employees may change. If I
appy the filter and change the employees, the new employees are not
automatically visible.

"Luke M" wrote:

You could apply a filter (Data, Filter, AutoFilter) and then have your filter
show everything that does not equal FALSE. (under custom)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kiley" wrote:

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"

--

Dave Peterson

I did create a macro but it will not work if I protect the worksheet. I need
to protect the worksheet so that the formulas cannot be changed. Is there a
way around this?

"Dave Peterson" wrote:

There's no formula that will hide rows.

You'll either need a macro or teach the users to show the data and filter it
again.

(If you teach them, they'll be able to use filters in lots of workbooks!)

Kiley wrote:

That works but I was hoping that there was a formula to help do this because
I am using this workbook as a template and the employees may change. If I
appy the filter and change the employees, the new employees are not
automatically visible.

"Luke M" wrote:

You could apply a filter (Data, Filter, AutoFilter) and then have your filter
show everything that does not equal FALSE. (under custom)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kiley" wrote:

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"

--

Dave Peterson

Your macro could unprotect the worksheet, do its work and reprotect the
worksheet.

Or you could protect the worksheet in code using the "userinterfaceonly" parm.

Saved from a previous post.

If you already have the outline/subtotals/autofilter applied, you can protect
the worksheet in code (auto_open/workbook_open??).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
'.EnableOutlining = True
.EnableAutoFilter = True
If .FilterMode Then
.ShowAllData
End If
End With
End Sub

It needs to be reset each time you open the workbook. (Earlier versions of
excel don't remember it after closing the workbook. IIRC, xl2002+ will remember
the allow autofilter setting under tools|Protection|protect sheet, but that
won't help when you're filtering via code.)

Kiley wrote:

I did create a macro but it will not work if I protect the worksheet. I need
to protect the worksheet so that the formulas cannot be changed. Is there a
way around this?

"Dave Peterson" wrote:

There's no formula that will hide rows.

You'll either need a macro or teach the users to show the data and filter it
again.

(If you teach them, they'll be able to use filters in lots of workbooks!)

Kiley wrote:

That works but I was hoping that there was a formula to help do this because
I am using this workbook as a template and the employees may change. If I
appy the filter and change the employees, the new employees are not
automatically visible.

"Luke M" wrote:

You could apply a filter (Data, Filter, AutoFilter) and then have your filter
show everything that does not equal FALSE. (under custom)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Kiley" wrote:

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"

--

Dave Peterson


--

Dave Peterson