Results 1 to 11 of 11

Creating Database of Names from Poor Electronic System Output with Primary Job Role

Threaded View

fedewaj Creating Database of Names... 07-20-2016, 11:11 AM
AB33 Re: Creating Database of... 07-20-2016, 11:53 AM
fedewaj Re: Creating Database of... 07-20-2016, 12:05 PM
AB33 Re: Creating Database of... 07-20-2016, 12:06 PM
fedewaj Re: Creating Database of... 07-20-2016, 12:16 PM
AB33 Re: Creating Database of... 07-20-2016, 12:43 PM
fedewaj Re: Creating Database of... 07-20-2016, 12:54 PM
AB33 Re: Creating Database of... 07-20-2016, 01:58 PM
fedewaj Re: Creating Database of... 07-20-2016, 02:14 PM
AB33 Re: Creating Database of... 07-20-2016, 02:27 PM
fedewaj Re: Creating Database of... 07-20-2016, 04:00 PM
  1. #1
    Registered User
    Join Date
    09-12-2014
    Location
    Dallas, TX
    MS-Off Ver
    2010
    Posts
    15

    Creating Database of Names from Poor Electronic System Output with Primary Job Role

    Hi Everybody,
    Previously, I posted on this topic (Creating Database of Names from Poor Electronic System Output) and I was able to create the list of names that I needed through a VBA written by JohnTopley - unfortunately I was not specific in stating that I needed Columns C-J included in converting K and L into this list of names.

    I'm hopeful that somebody can help me now update that list of names with the role that those persons were entered under in the electronic system (Principal Investigator - labeled as PI Last and PI First in columns C and D, Research Coordinator as RC Last and RC First, Primary Administrative Contact as PAC Last and PAC First, etc.). The additional criteria for assigning this role is based on the greatest number of times that person is assigned that role; for example, if I am a PI 2 times but a Research Coordinator 10 times, I want my primary role to be pulled out as Research Coordinator.

    If somebody can not only create this but also update JohnTopley's VBA (example database and his VBA attached to thread) to include all users from Columns C and D as one person, E and F as one person, G and H as one person, I and J as one person, and then break K and L into the individual people with their primary job role, that would be amazing.
    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. Creating Database of Names from Poor Electronic System Output
    By fedewaj in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-14-2016, 10:33 AM
  2. [SOLVED] Electronic file system - VBA to inform when dates are older than 10 days
    By ramatthews in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2016, 03:53 AM
  3. Creating Sub-Lists from 1 Primary List
    By SPF29 in forum Excel General
    Replies: 6
    Last Post: 02-19-2016, 03:08 PM
  4. [SOLVED] Split name and role, get rid of parentheses ex: Last, First (Role)
    By James Keuning in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-02-2014, 01:03 PM
  5. [SOLVED] Forecast output to ERP system
    By Vicarious in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-26-2014, 06:27 PM
  6. Creating Electronic Form Using Design Mode
    By AConneely in forum Excel General
    Replies: 4
    Last Post: 08-16-2012, 06:03 PM
  7. Primary key for database
    By yes sir in forum Access Tables & Databases
    Replies: 4
    Last Post: 08-21-2010, 09:20 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