Macro to Move Data into Another Column

Hello all,

Trying to write a macro that will move data from one column into another column based on the headers in row 1. I have two columns (RNotes and GNotes). These columns are not always next to each other, which is why I’d like to use the header in row 1 to identify. The data in GNotes needs to move into RNotes separated by a space.

In the attached example, the data in GNotes moves into RNotes and notes1 and Notes2 are separated by a space in the cell in the RNotes column.


Help is appreciated - thank you!

Question also posed at MrExcel: http://www.mrexcel.com/forum/showthread.php?t=536933