Hello,
I am dumping a contact list from a sales database and want to list all employees names and titles across one row of data. Additionally, each data row will have a primary employee name and then all other listed so if my database has 6 employees for one company I will have 6 rows of data - one for each individual employee with the five other employees listed in that same row. I am not good a VB or Macros so I have been trying vLookup, If Then, and Index with arrays. Nothing is working. Does anyone have any ideas? Attached is a sample set of data. The second worksheet in the file is the master data, the first page is where I would like to dump the data. I have sample data typed in to show shat the results should be (see orange highlighted fields on sheet 1). My Worksheet_2.xlsx.
Bookmarks