Hi,

Would like to ask your help or idea on this issue, i would like to display all the employee whose passport and visa is almost expired (30 days before expiry) to another
sheet. I have done conditional formatting highlighting both fields 30 days before expiry but i want to display the list on another sheet.



Your valuable input is highly appreciated.

Thanks