Hi,
Can someone help me fix following pls.
I need to sort out a table using a user defined sequence.
Let me explain more.
In Column 1 of my table I have lets say following
A
A
A
D
D
D
D
E
E
E
A
A
and in another sheet (priority), user can key in the preferred sequence no. against each unique ID from above Table
such as
A 2
D 3
E 1
Now I want macro to read the sequence no. from priority sheets and sort the Table in (Summary Page) for me.
Note: The summary Table is a live Table and values will be keep on adding in it and unique list is currently keeps on updating.
THANKS IN advance.....

Any suggestions pls. . . . .
Can someone help me fix following pls.
I need to sort out a table using a user defined sequence.
Let me explain more.
In Column 1 of my table I have lets say following
A
A
A
D
D
D
D
E
E
E
A
A
and in another sheet (priority), user can key in the preferred sequence no. against each unique ID from above Table
such as
A 2
D 3
E 1
Now I want macro to read the sequence no. from priority sheets and sort the Table in (Summary Page) for me.
Note: The summary Table is a live Table and values will be keep on adding in it and unique list is currently keeps on updating.
THANKS IN advance.....


Any suggestions pls. . . . .