Filter macro

[Alvaroro84]

Is it possible to create a macro that filters by using the headers name rather then the specific column? If so what would something like that look like?

 

[EXCEL MAX]

You should find column index by exact match and put it to variable and then use that index instead column name.
Example:

Sub FileterByHeader()

    vCHeader = Rows(1).Find("Header 2", , xlValues, xlWhole, , , True).Column
    Range("A1:E5").AutoFilter vCHeader, "Some Text"
    
End Sub

 

[Peter_SSs]

If the data happens to be in a formal Excel table (ListObject) then you could try something like this

Sub Fltr()
  With ActiveSheet.ListObjects(1)
    .Range.AutoFilter Field:=.ListColumns("Header 2").Index, Criteria1:="Some Text"
  End With
End Sub

 

[EXCEL MAX]

About my example.
If you are interested about look, using the match function code might look like this too.

    With ActiveSheet.Range("A1:E5")
        .AutoFilter Application.Match("Header 2", .Rows(1), 0), "Some Text"
    End With

 

[Alvaroro84]

Thank you for the reply i was wondering if it was possible to add columns based off a columns name

 

[Peter_SSs]

That sounds like a very different question. I suggest that you start a new thread for it.