+ Reply to Thread
Results 1 to 2 of 2

Help - Need to combine one list of names with a list of title to create multiple unique id

  1. #1
    Registered User
    Join Date
    02-07-2018
    Location
    Belfast
    MS-Off Ver
    2016
    Posts
    1

    Help - Need to combine one list of names with a list of title to create multiple unique id

    Hi,

    I need help creating a VBA/Macro, that will take a list of job titles and combine them with a list of countries to create multiple unique entries. e.g. Job title - Cleaner, countries GBR, USA, GER, FRA and the unique ID's will become CleanerGBR, CleanerUSA, CleanerGER, CleanerFRA. my challenge is I have c1000 job titles, and 32 countries - do the list will have c32000 unique ID's.

    can anyone help?

    thanks.

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Help - Need to combine one list of names with a list of title to create multiple uniqu

    you can use a formula or VBa
    formula
    https://www.excelforum.com/excel-cha...readsheet.html

    the vba with 2 loops will do the job

    Please Login or Register  to view this content.
    where the jobs are in column A (you need to say how many, change 1000)
    the counties in column B and likewise change the 32

+ 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. Create unique # of worksheets based on list count with unique names
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-24-2016, 09:51 AM
  2. Create a list that contains duplicates and unique names and no blanks
    By Whard42 in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-24-2015, 08:43 AM
  3. [SOLVED] Looking to create a list of unique names that match criteria without using an array
    By john dalton in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-28-2014, 04:28 AM
  4. [SOLVED] create multiple files using save as with list as title
    By dbrubaker in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-10-2012, 02:14 PM
  5. create list from multiple names
    By scabertrain in forum Excel General
    Replies: 2
    Last Post: 11-07-2008, 11:10 AM
  6. Replies: 3
    Last Post: 01-16-2006, 02:10 AM
  7. Need to create unique list from list of multiple entries
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2005, 01:05 AM

Tags for this Thread

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