CONCATENATE FOR TWO OR MORE CONDITION (vba)

[ionmihairo]

Hello All,

I need help with a VBA code if it possible . I have a table and I need to concatenate cells for two conditions.


I attached the table for better understanding.

In cell B1 I type the date
I cell C2;C3 etc I type the number of the route
In cell D2 I need to appear the concatenated information from D19:D100 - F19:F100 according to the number of the route and the date.

Thank you very much for your help.
DELIVERY sample.xls

[rylo]

Hi

Maybe a UDF.

Please Login or Register  to view this content.

In your example file it would be called by
D2: =myfunc($B$1,C2,$A$19:$A$66) Copy down to D4.

Note that you will have to change the date to be 23/10/2012 for your example data.

HTH

rylo

[ionmihairo]

Hello Rylo,

Thank you very much for your help. It is working perfectly . You spare me a lot of work. I own you one.

With warm regards and many many many tanks!