filter table in excel vba

Question

New to excel vba, Sorry if this is too obvious...
I got this data in spreadsheet,
How can filter out the table by "title" column
So I will be able to select part of the table by filtered by title
thanks

book name       Description                             title
gsod        Samples from US weather since 1929          title1
mlab        Measurement data of performance             title1
natality    Birth States from 1969 to 2008              title2
shakespeare Word index for works of                     title2
wikipedia   Revision information for Wikipedia          title1

what version of Excel are you using? In Excel2007 and 2010 you can just select the data and 'Format as a Table', after that the headers get a triangle next to them which you can click to filter — Amber
– Amber, Commented Oct 15, 2013 at 14:51

excelVBAmaster.com · Accepted Answer · 2013-10-15 15:18:37Z

2

A simple example to accomplish what you are trying to do is:

Sub SortColumnC()

If Sheets(1).AutoFilterMode = False Then
    Sheets(1).Range("A1:C1").AutoFilter
End If

RowCount = Sheets(1).Range("A" & Rows.Count).End(xlUp).Row
ActiveWorkbook.Worksheets(1).AutoFilter.Sort.SortFields.Clear
ActiveWorkbook.Worksheets(1).AutoFilter.Sort.SortFields.Add Key:=Range("C2:C" & RowCount), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets(1).AutoFilter.Sort
    .Header = xlYes
    .MatchCase = False
    .Orientation = xlTopToBottom
    .SortMethod = xlPinYin
    .Apply
End With

End Sub

answered Oct 15, 2013 at 15:18

excelVBAmaster.com

1581 gold badge2 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JavaSheriff Over a year ago

I Have found a working solution: stackoverflow.com/questions/10849177/…

Collectives™ on Stack Overflow

filter table in excel vba

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related