In A1 enter

=ROW()

and copy down

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"naughtyboy" wrote
in message ...

i have following numberssssss.....
A1
1
2
3
4
5
6
7
8
upto 1000...
when i delete the numbers for example 4 and 7 then the other names
remain same but i want taht list should me changed sorted automatically
..
i mean when i delete 4 and 7 then list should be changed automatically
like this...
1
2
3
4
5
6..i mean serial number should be changed...as befor edeleting they
were 8 but when i delete 2 numbers from them then there should be 6
numbers and they must be serial... thanks


--
naughtyboy
------------------------------------------------------------------------
naughtyboy's Profile:
http://www.excelforum.com/member.php...o&userid=37151
View this thread: http://www.excelforum.com/showthread...hreadid=569186