I would like to run an Excel Macro that performs the following actions:
Select all the cells which need to be copied into the clipboard.
Paste the whole contents into just one cell
(5 cells to the right relative to the first cell that gets copied) whereby the individual cell entries get separated by a manual line break (Alt+Enter)
I have attached a sample file for your convenience.
Help is much appreciated. Thank you very much in advance.