+ Reply to Thread
Results 1 to 2 of 2

Generating a Key

  1. #1
    Valued Forum Contributor
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,241

    Generating a Key

    MOVED from this thread:

    i have same problem key in col A and item in b-i

    Please Login or Register  to view this content.
    Screenshot_111.png
    Last edited by JBeaucaire; 03-05-2017 at 09:38 PM. Reason: Moved to its own thread. Please read and follow the Forum Rules, link above in the menu bar.

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: Generating a Key

    I suggest the code below, which doesn't require reading data into arrays or creating a key. I've used the sort special feature that allows you to sort by lists; in this case, a preset one being the months of the year. You'll need to change the "CustomOrder" line to the non-English month names. File also attached.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generating list
    By her.rockstar in forum Excel General
    Replies: 17
    Last Post: 06-26-2013, 07:51 AM
  2. New Invoice Generating
    By ady armstrong in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2012, 11:00 PM
  3. Generating Lists
    By Guitara in forum Excel General
    Replies: 0
    Last Post: 08-09-2012, 01:56 PM
  4. Need help generating an autonumber
    By rbpd5015 in forum Excel General
    Replies: 7
    Last Post: 05-21-2012, 10:47 AM
  5. generating links?
    By sbrooky in forum Excel General
    Replies: 2
    Last Post: 06-15-2009, 11:01 AM
  6. Generating New Date
    By markw2k in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-18-2009, 01:49 PM
  7. Help generating combinations
    By JamRock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2006, 03:40 PM
  8. [SOLVED] Generating a table
    By Comicfly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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