[Solved] conditionally concatenate text from multiple records in vba [duplicate]
[ad_1] 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”) … Read more