Filter Inactive status based on Leave Date|VBA & Macros|Excel Forum|My Online Training Hub

Hi Nabila,

1. If the user "Leave date" 13-Jul-22", "Payroll Status" is "Inactive".

 The result in "Active" field is "No" and "custom_field: Last day of work" is 13/07/2022

 

2.  If the user "Leave date" 31-Aug-22", "Payroll Status" is "Inactive". 

The result in "Active" field is "Yes" and "custom_field: Last day of work" is 31/08/2022

For RangeToFilter, you have set an Autofilter:

.AutoFilter Field:=9, Criteria1:="=Active"

Therefore, these entries with Inactive will not show up in the filtered sheet. If you want them to show up in the filter sheet, don't filter them out.

This loop can be cleaned up, formatting should be done outside the loop: