I guess a routine to

2 - sort Table in Sheet2 by Manager

So if I copy table 1 to table 2 and update table 1, it will auto update
table 2 and sort table 2 by Manager (table 1 is already sorted/created
by user id).

I have hardly use excel.

Thank You

Kim


--
heatmiserkmp
------------------------------------------------------------------------
heatmiserkmp's Profile: http://www.excelforum.com/member.php...o&userid=28463
View this thread: http://www.excelforum.com/showthread...hreadid=480699