How to write a macro to concatenate 2 specific columns into another specific column

Hey guys I have been working on some code to concatenate 2 columns with data into another column. I want to be able to have a macro that is tied to a button that when I press the button it automatically concatenates 2 specific columns(Must be able to specify which columns in the code) into another specified column. For example, I would like to have a macro that concatenates column C2+M2 and gives me the values of that into O2. I'm kind of new to Excel programming and trying to learn how to use it for work purposes. I currently have a macro set up that does something similar but it is not set for specific columns, it only has a starting column, which will then concatenate the column to the right and give me the values into the following column if that makes sense. Here is the code I have so far:

Sub concatecells()
Dim scell As Range
Set scell = Range("C2") '<==set start cell here.
Dim os As Double: os = 0
Do Until scell.Offset(os, 0) = ""
scell.Offset(os, 2).Value = scell.Offset(os, 0).Value & " " & scell.Offset(os, 1).Value
os = os + 1
Loop
End Sub

Any help would be greatly appreciated.

This seems to work! Although I am looking for a macro that would automatically concatenate the two columns and have a designated location for the values. I attached a picture as an example. For column C and D the button would automatically concatenate those to columns and designate those values in column E. I would also like to have another button(Probably would require multiple modules for each macro and I am worried about it slowing down the template) That would concatenate Column C and G and output those values in Column H for example. Sorry if this is confusing. Your code works very well but I am trying to create a template that has a button assigned to different macros that are specific for concatenating certain columns into other specific columns.

Screen Shot 2018-05-27 at 3.00.27 PM.png

Also does the column entry have to be numeric? Or could I have it ask me for the alphabetical figure for that specific column? Thanks again.

Or similar but different.

Please Login or Register  to view this content.

Click anywhere in the first column for the first inputbox, anywhere in the second column for the second inputbox and anywhere in the column where you want the result for the third inputbox.
You can run the same macro for as many concatenations as you want.

The site won't let me post the code so I've uploaded a file