How do I link sorted data to other workbook sheets?
I'm trying to create a workbook with the first sheet being a general list of
issues with assignment to different persons. The general list is set up as a
list that I can sort depending on the urgency of an issue, the person
assigned to the issue, etc. I would like to be able to create links to other
sheets within the workbook designated one to each person named as assignee in
the original issue list. How do I set it up so that when an issue is inputed
into the main sheet designated to A, the issue will automatically appear on
A's personal sheet?
|