I know there is an answer to this because I've seen it done...but I can't find the thread I've reviewed in the past.
What I'm trying to solve.
I have a list of over 1000 names in multiple departments. I'm trying to extract all of the names to a specific department, and put those names on the department tab but the list grows to capture all of the names from a specific department. Then, I want to move to the next tab (new department) and have the formula pull all of the names from the list for that specific department.
I do not know VBA so a formula would be very helpful.
Thanks in advance for your help.
RCM
What I'm trying to solve.
I have a list of over 1000 names in multiple departments. I'm trying to extract all of the names to a specific department, and put those names on the department tab but the list grows to capture all of the names from a specific department. Then, I want to move to the next tab (new department) and have the formula pull all of the names from the list for that specific department.
I do not know VBA so a formula would be very helpful.
Thanks in advance for your help.
RCM