+ Reply to Thread
Results 1 to 2 of 2

Automatically number spreadsheet

  1. #1
    Registered User
    Join Date
    07-06-2009
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    4

    Automatically number spreadsheet

    Hi,

    I have an equipment list that needs to have a fixed Ref number inserted into the 3rd Column c whenever there is a quantity entered into the 13th Column M.

    This I understand is quite easy to achieve with a formula, however the tricky part is when I need to add a row.

    The new Row,( inserted below the active cell needs to be numbered with the Same # as the Row above + a 2 digit decimal point . For Example. I need to Insert a Row between Row 10 and Row 11. The Row is inserted, the formulas are copied down and the row is numbered 10.01. If I need to add a 2nd Row, that row is numbered 10.02. The row after that is still Row 11.

    SO the Ref Column would look like this :
    10
    10.01
    10.02
    11

    These numbers would not change once they have been entered and if possible they should be locked.

    Thanks for any help and or advice

    DMWllC

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Automatically number spreadsheet

    is this in the right forum? You're posting in the Access Programming forum, but you talk about spreadsheets.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1