I have column like below

serialno requester qty
1. richard 6
2. jack 4
3. richard 3
4. jack 3

Howver once I activated "Data/Filter/Autofilter" on requestor, I wish
to have the "serialno" renumbered in sequence. Tq.

Mangchik


--
mangchik
------------------------------------------------------------------------
mangchik's Profile: http://www.excelforum.com/member.php...o&userid=35993
View this thread: http://www.excelforum.com/showthread...hreadid=558871