Convert formula to values and wrap text automatically

Hi

At "BuildMaster" sheet, when user updates hostname and IP address, automatically concatenate at column F12.

Would like to incorporate the below formula at Column F and then convert to value and also would like to automatically merge column D and Column F after double click the last row in macros.
=IF(BuildMaster!$B12<>"",BuildMaster!$B12&" "&CHAR(10)&BuildMaster!$C12,"")

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim LR As Integer
If Target.Column > 1 Then Exit Sub
Cancel = True
If MsgBox("Do you want to insert a new row below this row?", vbYesNo) = vbYes Then
Target.Resize(1, 14).AutoFill Destination:=Range(Target, Target.Offset(1, 13)), Type:=xlFillDefault
Target.Offset(1, 0).Resize(1, 2).ClearContents
Target.Offset(1, 1).Resize(1, 2).ClearContents
End If
LR = Empty
End Sub

I have set the marcos but tried to incorporate both requirements inside but it doesn't work as I still new to macros.
Would appreciate your assistance on this form. Thank you.

Hi,

Would appreciate can anyone assist with your expert solution, please?

At "BuildMaster" sheet, when user updates hostname and IP address, automatically concatenate at column F12.

Would like to incorporate the below formula at Column F and then convert to value and also would like to automatically merge column D and Column F after double click the last row in macros.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have set the marcos but tried to incorporate both requirements inside but it doesn't work as I still new to macros.
Would appreciate your assistance on this form. Thank you.

Hi
My apology for not putting in codes as this is the first time I am adding vba in excel forum.
Would like to have your assistance in resolving this issue. It will be a great help.

Thank you.