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?

One play to try ..

In Sheet1
-------------
Assume the "master" table is in cols A and B
data from row2 down
(with the key column "Assignee" in col B), viz:

Issue Assignee
------- -------------
Issue1 Peter
Issue2 Joshua
Issue3 Lester
Issue4 Peter
Issue5 Lester
Issue6 Joshua
etc

List across in say, G1:I1
the Assignees: Peter, Joshua, Lester

Put in G2: =IF($B2="","",IF($B2=G$1,ROW(),""))

Copy G2 across to I2, then fill down by a safe "max"
number of rows that data is expected in cols A to B,
say, down to I200?

In a new sheet named: Peter
---------------------------------------
Let's reserve cell A1 for the Assignee name

Put in A1:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

(This'll extract the sheetname into A1.
But you need to save the file first.)

Put in A2: "List" (as a col header)

Put in A3:
=IF(ISERROR(MATCH(SMALL(INDIRECT("Sheet1!$"&CHAR(M ATCH($A$1,Sheet1!$1:$1,0)+
64)&":$"&CHAR(MATCH($A$1,Sheet1!$1:$1,0)+64)),ROW( A1)),INDIRECT("Sheet1!$"&C
HAR(MATCH($A$1,Sheet1!$1:$1,0)+64)&":$"&CHAR(MATCH ($A$1,Sheet1!$1:$1,0)+64))
,0)),"",OFFSET(Sheet1!$B$1,MATCH(SMALL(INDIRECT("S heet1!$"&CHAR(MATCH($A$1,S
heet1!$1:$1,0)+64)&":$"&CHAR(MATCH($A$1,Sheet1!$1: $1,0)+64)),ROW(A1)),INDIRE
CT("Sheet1!$"&CHAR(MATCH($A$1,Sheet1!$1:$1,0)+64)& ":$"&CHAR(MATCH($A$1,Sheet
1!$1:$1,0)+64)),0)-1,-COLUMN(A1)))

Note: You'd need to correct / restore the couple of inadvertent line wraps /
line breaks when you copy paste the above formula into A3

Copy A3 down by as many rows as was done
in Sheet1's cols G:I, i.e. down to A200 thereabouts

You'll see that col A (in row3 down)
will auto-return the "filtered" rows from Sheet1
for the Assignee: Peter
i.e. for the sample data-set above, it'll appear as:

Peter
List
----
Issue1
Issue4

Now, just duplicate / make a copy of the sheet: Peter,
rename it as: Joshua
and you'll get the "filtered" rows for Joshua:

Joshua
List
----
Issue2
Issue6

Repeat the sheet duplicating and renaming
for: Lester and you'll get:

Lester
List
----
Issue3
Issue5

And so on ..

Issues entered to the assignees in Sheet1
will auto-appear in each assignee's "personal" sheet

Adapt / extend to suit
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Cori" wrote in message
...
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?