simplest way would be by writing formula A3= IF(B3<>"", A2+1,"")
place this formula in A3 cell. and drag it till bottom. So, whenever you enter the value.. it will add number in a3 Regards, Sarfaraz Ahmed On Sun, Dec 27, 2009 at 4:28 AM, kvc praveen kumar <pkkara...@gmail.com>wrote: > Hi Rafique, > > You need not worry about the autonumbers. Just keep filling your names, > After you are done select cells containing 1,2 in S# column and then double > click the fill handle. Excel will automatically genearate the sequence for > you. > > Let me know if this helps!! > > Regards, > Praveen KVC > > > On Sat, Dec 26, 2009 at 10:02 PM, MRafique <imrafiqu...@gmail.com> wrote: > >> Hi Friends >> >> Please help me how to insert auto numbers in worksheet. Like >> >> Cell 1 Cell 2 Cell 3 >> ============================================== >> S# Name Designation >> 1. Muhammad Rafique Social Organizer >> 2. ABCD XYZ >> >> Now I want that when I add new name in cell 2 serial number may come >> automatically. How? >> >> Waiting for your positive response. >> >> Thanks >> >> Muhammad Rafique >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us in TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,500 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks with regards, Sarfaraz Ahmed <a target="_blank" href="http://feeds2.feedburner.com/~r/blogspot/rtws/~6/6";><img src="http://feeds2.feedburner.com/blogspot/rtws.6.gif"; alt="Free MS Excel help" style="border:0"></a> -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
![http://feeds2.feedburner.com/blogspot/rtws.6.gif"](http://feeds2.feedburner.com/blogspot/rtws.6.gif"){kind=link}