Select/Sort Hierarichal Data in worksheet

[S. Sakthivel]

Hi,

I need to Filter or Sort out the Hirearichal Employee and Manager
information from below sample data structure.

Empno Ename MGR Deptno
101 A 105 10
102 B 104 10
103 C 102 20
104 D 10
105 E 103 20


I want the Sorted/Filtered Data as per below.

Empno Ename MGR Deptno
104 D 10
102 B 104 10
103 C 102 20
105 E 103 20
101 A 105 10

Kindly help me how to do the above in MS Excel 2003?

 

[Socko]

please can you be more specific...

Selva V Pasupathy
For more on Excel, VBA, & other resources
Please visit http://socko.wordpress.com/

 

[S. Sakthivel]

Hi Socko,

I have the data in my worksheet as per below.

Empno Ename MGR Deptno
101 A 105 10
102 B 104 10
103 C 102 20
104 D 10
105 E 103 20

I want to make filter the above data as per below model(Hirearichal). i.e. I
need to display the above data from the top manager grade to lower. Here top
manager is 104. Because he is not working under any Manager. Also you can
employee 104 is working under the manager 104. And 102 is manager of employee
103...

Empno Ename MGR Deptno
104 D 10
102 B 104 10
103 C 102 20
105 E 103 20
101 A 105 10

Kindly help me how to filter the data as per my explaination.

Thanks & Regards,
S. Sakthivel

 

[S. Sakthivel]

Hi Socko,

I have the data in my worksheet as per below.

Empno Ename MGR Deptno
101 A 105 10
102 B 104 10
103 C 102 20
104 D 10
105 E 103 20

I want to make filter the above data as per below model(Hirearichal). i.e.

If i filter the MGR field is "104" means, it should come as per below.

Empno Ename MGR Deptno
104 D 10
102 B 104 10

Kindly help me how to filter the data as per my explaination.

Thanks & Regards,
S. Sakthivel