I have been given a task to compile a mater list of documents, and the people who have access to them.
Here is an example of what I am working with
I have compiled a master list of all the documents. What I need to do now is list what people need to still complete these documents (the ones with the "N" in the columns)
So far I have 3 workbooks with document numbers and the status per person, but I am expecting a few more.
How do I go about listing the people with "N" on my master sheet? I would like it to look something like this, pulling names from each sheet if they are there.
Here is an example of what I am working with
I have compiled a master list of all the documents. What I need to do now is list what people need to still complete these documents (the ones with the "N" in the columns)
So far I have 3 workbooks with document numbers and the status per person, but I am expecting a few more.
How do I go about listing the people with "N" on my master sheet? I would like it to look something like this, pulling names from each sheet if they are there.
