[Solved] conditionally concatenate text from multiple records in vba [duplicate]
Try the below code, it assumes you have headers and that unique ID is in column A and description in column B. Option Explicit Sub HTH() Dim vData As Variant Dim lLoop As Long Dim strID As String, strDesc As String ‘// Original data sheet, change codename to suit vData = Sheet1.UsedRange.Value With CreateObject(“Scripting.Dictionary”) .CompareMode … Read more