+ Reply to Thread
Results 1 to 2 of 2

Collate list of names(from headers)

  1. #1
    Registered User
    Join Date
    12-19-2014
    Location
    Portsmouth, England
    MS-Off Ver
    Office 2010
    Posts
    1

    Collate list of names(from headers)

    Hello All,
    New to these forums and I said I would try to help a friend with an excel program but i am stumped.
    Help.jpgHelp.jpg
    Attached is screencap of my tester sheet, and as you can see the document names are down the first column(Blue) and names are along the top(Red).
    The information in black is what permissions people have to each corresponding document. The actual document has over 300 names and many more documents.
    My friend wants to have column at the end listing the names of people assigned with each permission as shown in the attachment.
    Without having to do this manually which would take a long time is there anyway of looking through B2-H2 for "Lead Reviewer" then finding the corresponding names in A2-H2, then putting these list of names together in I2.
    Having looked everywhere on the internet I have found this hard to describe so have been unable to find anything like this.

    Any help will be greatly appreciated.

    Thanks

    Luke

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    Re: Collate list of names(from headers)

    Suggest you post a sample workbook rather than a picture of it.

    If there were a single entry for each permission, you could probably do it with INDEX/MATCH but, as there could be more than one, I suspect that you will need a User Defined Function (UDF) written in VBA.

    Regards, TMS


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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] Draw random names from list and then remove, carry on till no names left in list
    By dave1983 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-26-2014, 12:14 PM
  2. Formula which will collate names into a collumn
    By rodduz in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 09-19-2014, 06:23 AM
  3. [SOLVED] Compile/Collate information from list into one email per person
    By Aaron092 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2014, 07:53 AM
  4. Replies: 9
    Last Post: 10-14-2013, 07:55 PM
  5. Collate a list of unique items only from multiple sheets into specific categories
    By Boyler_Room in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2013, 08:05 PM

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