Hi,
I am new to this thread and would like to ask a question.
Attached is a sample sheet. The original sheet has about 33k of lines and 24 columns and is updated about 3 times a week, sometimes everyday.
I would like to know if there is a way based on column B and D to list only the active sales agents to the "Active" sheet and to have it automatically update when the Employee list is updated.
I know that this could be done manually but I would just like to know if there is a way to automate.
I am new to this thread and would like to ask a question.
Attached is a sample sheet. The original sheet has about 33k of lines and 24 columns and is updated about 3 times a week, sometimes everyday.
I would like to know if there is a way based on column B and D to list only the active sales agents to the "Active" sheet and to have it automatically update when the Employee list is updated.
I know that this could be done manually but I would just like to know if there is a way to automate.