Results 1 to 5 of 5

Automatic numbering by category

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-12-2006
    Location
    Portugal
    MS-Off Ver
    Microsoft 365 Apps for enterprise
    Posts
    212

    Automatic numbering by category

    I don’t think there is a way of putting this to work without VBA but let’s see…
    In the uploaded worksheet user will choose the Category in Column B, according to the data validation of the ‘sublist’ named range. If there is no chosen Category (column B is empty), no automatic numbering should be used. If there is a chosen Category then the automatic and sequential numbering should occur on column C as mocked up in the worksheet.
    Many thanks in advance for any kind help.
    Octavio
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatic numbering
    By Immortal2014 in forum Excel General
    Replies: 3
    Last Post: 06-27-2016, 04:49 AM
  2. Automatic Sum by Category (SumIf extension)
    By ezuk in forum Excel General
    Replies: 1
    Last Post: 08-12-2005, 02:05 AM
  3. [SOLVED] automatic numbering-How can this be done?
    By Michael1959 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2005, 04:05 PM
  4. Automatic Numbering
    By Javster95 in forum Excel General
    Replies: 5
    Last Post: 05-01-2005, 03:06 PM
  5. Automatic Numbering.
    By Javster95 in forum Excel General
    Replies: 0
    Last Post: 04-30-2005, 03:06 PM

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