Results 1 to 7 of 7

Autonumber when choosing text

Threaded View

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    5

    Autonumber when choosing text

    Hi all,

    I would like to generate a unique number(in column A, worksheet BREEAM) when choosing an item from my dropdown in colomn C(see example).
    I tried numerous things but with al the options I've tried it works fine untill i'm going to use the sort options.

    So what I would like to do is:
    - Generate a unique number when there's text in Column C.
    - This unique number needs to be generated automatically and checks which is the highest number in column A + 1
    - It shouldn't renumber al the items when using the sorting options.

    Can anybody point me in the right direction?

    Thanks in advance and Kind Regards
    Machiel
    Attached Files Attached Files

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