Excel: Concatenateing and entire row automaticalls

Hello everybody I need to automatically CONCATENATE row 8 of my worksheet into cell A21 of the same worksheet. The values in row 8 are dynamic so the concatienation should work life a function or a module. Does anybody have an idea on how this can be achieved ? Thanks in advance

This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of December 17, 2014.

For more resources for Microsoft Excel