LookUp Value and Concatenate All Found Results

[jeffwtn]

I think Admin posted the solution for you in Message #32... you need to save the workbook as an "Excel Macro-Enabled Workbook (*.xlsm)" and NOT as plain "Excel Workbook (*.xlsx)". When you save the workbook with the macro code in place, click the drop-down under the "File name" field (it is labeled "Save as type:") and select what should be the second item in the list (with the wording I show above). After that, when you reopen the workbook, you will have to click the button to enable the macro code.

Hi Thanks,

I have retry to do it , still not joy. At first even .xlsx working fine but after a while it just does not work anymore
file attached. Thanks again



Jeff