Hi Guys,
Hope you can help. I'm looking for a VBA macro that can solve my problem.
I want the macro to go down column C and column D looking for a match with the row below and the row below that etc. and then concatenate column E in to column F. That's the easy bit. The tricky bit is concatenating column E of all the column C and column D matches into the first row of the first match. Hope that makes sense. If there is not a match with the row below concatenate column C and column D into column F.
Alex V
A B C D E USA 1 scott st Acme Company 1 Service Type 1 Sub service 432 France 1 scott st Acme Company 1 Service Type 1 Sub service 123 Italy 2 scott st Acme Company 2 Service Type 2 Sub service 321 Canada 2 scott st Acme Company 2 Service Type 2 Sub service 453 Germany 2 scott st Acme Company 2 Service Type 3 Sub service 476 Bolivia 3 scott st Acme Company 3 Service Type 2 Sub service 766 Brazil 4 scott st Acme Company 4 Service Type 3 Sub service 333 Brazil 4 scott st Acme Company 4 Service Type 3 Sub service 367
Expected outcome:
A B C D E F USA 1 scott st Acme Company 1 Service Type 1 Sub service 432 Sub service 432, Sub service 123 France 1 scott st Acme Company 1 Service Type 1 Sub service 123 Italy 2 scott st Acme Company 2 Service Type 2 Sub service 321 Sub service 321, Sub service 453 Canada 2 scott st Acme Company 2 Service Type 2 Sub service 453 Germany 2 scott st Acme Company 2 Service Type 3 Sub service 476 Sub service 476 Bolivia 3 scott st Acme Company 3 Service Type 2 Sub service 766 Sub service 766 Brazil 4 scott st Acme Company 4 Service Type 3 Sub service 333 Sub service 766, Sub service 333 Brazil 4 scott st Acme Company 4 Service Type 3 Sub service 367
Bookmarks