<div>
This will work, you just have to add in new conditions for the Headers you are looking for:<br />
<br />

<pre><code id="code-20-41906375-1">Sub UpdateHeader()

    For i = 1 To 100
        Columns(1).Select
        If Columns(i).Value = &quot;Product ID&quot; Then
            Columns(i).Value = &quot;PALLET ID&quot;
        ElseIf Columns(i).Value = &quot;Div&quot; Then
            Columns(i).Value = &quot;CATEGORY&quot;
        End If
    Next

End Sub</code></pre>
</div>


This will work, you just have to add in new conditions for the Headers you are looking for:



Sub UpdateHeader()

    For i = 1 To 100
        Columns(1).Select
        If Columns(i).Value = "Product ID" Then
            Columns(i).Value = "PALLET ID"
        ElseIf Columns(i).Value = "Div" Then
            Columns(i).Value = "CATEGORY"
        End If
    Next

End Sub

<div>
Thank you so much! This was a great help!
</div>


Thank you so much! This was a great help!

<div>
<div class="content wysiwyg-content">
I have a spreadsheet with column headers. I would like to create a macro that would rename the column headers based on the value. For instance, one column is Product ID. I would like to change that to PALLET ID. There are other columns that I would need to rename as well.<br />
<br />
Because the column place can be different depending on the file, I would like the macro to be able to find that column name and rename it based on the set criteria.<br />
<br />
Product ID = PALLET ID<br />
Div = CATEGORY<br />
<br />
So forth and so on.
</div>
</div>


I have a spreadsheet with column headers. I would like to create a macro that would rename the column headers based on the value. For instance, one column is Product ID. I would like to change that to PALLET ID. There are other columns that I would need to rename as well.

Because the column place can be different depending on the file, I would like the macro to be able to find that column name and rename it based on the set criteria.

Product ID = PALLET ID
Div = CATEGORY

So forth and so on.

Macro

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.