Archive

Posts Tagged ‘excel filter’

Excel Vba : Filtering With Text Boxes

July 28, 2017 Leave a comment

A nice filtering template.

The value in textbox is searched as part or whole in the column.

The results found are shown in the column, the other data are hidden.

Sample workbook can be downloaded here

Filtering Data and Copying

June 3, 2015 Leave a comment

          The filtered data is copied to another page  with a button.It was elected for to copy A and H columns .

Sheets("Data").Range("A2:H65536").SpecialCells(xlCellTypeVisible).Copy 
Destination:=Sheets("Sample").Range("A2") 

filteringdata

Download Template