Seen a number of different functions to concatenate, but none that quite match what I need:
In simple form, I would like a vba function on Summary sheet Column B which will lookup and concatenate the sub-project descriptions found on the "Detail" sheet, and if they have the project code indicated in Column A. Much like "SUMIF" formula, only "CONCATENATEIF"
Detail:
Code Description Budget
AK365 Safina community project 35000
AK365 Community develop projects 13500
AK420 Scholarship for children 32000
Subtotal 610500
AS540 Education - City C complete 4 classrooms 40000
AS540 Education - City A, 3 classroom blocks; 40000
AS540 Education - City B add one classroom block 13000
AS540 Education - City D need 3 classrooms 13000
AS540 Education - City E upgrade facilities of 2 classrooms; 7000
AS540 Education - City F 4 classrooms; 10000
AS540 Education - City G needs 2 classrooms; 7000
AS540 Education - City H 3 classrooms.* 10000
To yield
Summary:
Code Description Budget Total
AK365 Safina community project; Community develop projects 48,500
AK395 Medical center 530,000
AS540 Education - City A, 3 classroom blocks; ; Education - City B add one classroom block; Education - City C complete 4 classrooms; Education - City D need 3 classrooms; Education - City E upgrade facilities of 2 classrooms; ; Education - City F 4 classrooms; ; Education - City G needs 2 classrooms; ; Education - City H 3 classrooms.* 140,000
Please see the attached sample workbook.
Thanks,
Mark
PS. I am new to posting, so please let me know if I need to clarify more.
Bookmarks