Merge Two Columns

[MSmithson]

Hello all,

Just need a little help writing a macro that will merge two columns together. The columns marked “Retained Notes” and “Frozen Notes” need to be merged into one column simply marked “Notes.” The text (if any) in both columns needs to be merged into one cell in a single column with a space between the text. “Retained Notes” and “Frozen Notes” are the headers in row one. Retained Notes and Frozen Notes are always next to each other, but sometimes not in the same column letter (sometimes in col P sometimes in col O somtimes in col N, etc.). This is why I want to use the column headers in row 1 to identify the columns to merge.

See attached example.

[NBVC]

Your sample is very small and does not clearly show what you mean by:

The text (if any) in both columns needs to be merged into one cell in a single column with a space between the text. “Retained Notes” and “Frozen Notes” are the headers in row one. Retained Notes and Frozen Notes are always next to each other, but sometimes not in the same column letter (sometimes in col P sometimes in col O somtimes in col N, etc.). This is why I want to use the column headers in row 1 to identify the columns to merge.

[MSmithson]

Here is another sample that might better illustrate what I mean:

[NBVC]

Wouldn't then this formula:

=Before!B2&" "&Before!C2

copied down do it?

[MSmithson]

Yes, however, I am trying to automate this process with a macro. Also, Retained Notes and Frozen Notes are not always in cols B and C. In some worksheets, they are in cols A and B, others they are in cols F and G, etc. This is why I want to use the header in row 1 to identify these cols to merge.

[NBVC]

That is why I asked for a better sample... your sample doesn't illustrate the variations...

Someone can hopefully come along with a VBA solution for you...

[MSmithson]

That would be great - here's an additional sample: