Number List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I use Fill Series to number a list of names from 1 - 50, & I delete 1 or more names from the list, how do I get the numbers to automatically re-number & reflect the fact that names have been removed from the list without having to use the Fill Series option every time. I would appreciate any help!
 
Asked somewhere today. Homework?
=row()
copy down

--
Don Guillett
SalesAid Software
(e-mail address removed)
Sue said:
If I use Fill Series to number a list of names from 1 - 50, & I delete 1
Click to expand...
or more names from the list, how do I get the numbers to automatically
re-number & reflect the fact that names have been removed from the list
without having to use the Fill Series option every time. I would appreciate
any help!
 
----- Don Guillett wrote: ----

Asked somewhere today. Homework
=row(
copy dow

--
Don Guillet
SalesAid Softwar
(e-mail address removed)
Sue said:
If I use Fill Series to number a list of names from 1 - 50, & I delete
Click to expand...
or more names from the list, how do I get the numbers to automaticall
re-number & reflect the fact that names have been removed from the lis
without having to use the Fill Series option every time. I would appreciat
any help

Thank you for your help, but if I am on line 14 of the worksheet how do I start with number 1
 
Back
Top