I am mildly experienced with Excel and have been trying to pick up some VBA knowledge. I have a workbook with 2 sheets, on sheet 1 i have big data set table and on sheet 2 I have a list of ID's and Type (String). The ID's from Sheet 2 correspond with a row in Sheet 1, the ID field is a primary key. So on Sheet 1 there is only one instance of a particular ID, and on sheet 2 ID could be listed multiple times depending to the number of types associated with that ID.
I am trying to create a vba solution to go through list of ID's on sheet 2 and match with sheet1 ID and then add a column or columns that would list the TYPES from Sheet 2 list.
The end result would be the unique ID on Sheet1 would then have all the TYPES associated with it listed horizontally after the other columns corresponding to the unique ID.
Hope I worded that right, any help would be appreciated.