Check if Columns match array, report or insert missing columns

[Gingertrees]

How would I check to see if columns on my sheet match a set array of column names?

Array :

("Concatenate", "Report Item No", "Area Code", "Phone Start", "Phone End", "Name")

So my sheet ideally looks like this:

Concatenate	Report Item No	Area Code	Phone Start	Phone End	Name	ID23	ID33	ID42
5615551212BD	1	561	555	1212	BDoe	x	e	y
6041238888AT	2	604	123	8888	ATann	r	e	r

<tbody>
</tbody>

I'd like info on which columns are missing. Any chance I could add code to insert missing columns at the right places??

Thanks.

 

[onlyadrafter]

Hello,

have hard-coded the requirements. Which will also insert the columns and its heading

Sub CHECK_COLUMNS()
        If UCase(Cells(1, 1).Value) <> "CONCATENATE" Then
            Columns(1).Insert
            Cells(1, 1).Value = "Concatenate"
        End If
        If UCase(Cells(1, 2).Value) <> "REPORT ITEM NO" Then
            Columns(2).Insert
            Cells(1, 2).Value = "Report Item No"
        End If
        If UCase(Cells(1, 3).Value) <> "AREA CODE" Then
            Columns(3).Insert
            Cells(1, 3).Value = "Area Code"
        End If
        If UCase(Cells(1, 4).Value) <> "PHONE START" Then
            Columns(4).Insert
            Cells(1, 4).Value = "Phone Start"
        End If
        If UCase(Cells(1, 5).Value) <> "PHONE END" Then
            Columns(5).Insert
            Cells(1, 5).Value = "Phone End"
        End If
        If UCase(Cells(1, 6).Value) <> "NAME" Then
            Columns(6).Insert
            Cells(1, 6).Value = "Name"
        End If
End Sub

Does this work as required?

 

[Gingertrees]

That does work - I am a little concerned that it will go slow when I increase the number of columns, though.
Thank you.