Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba code to copy filtered data

Tom Warren answered on May 11, 2023 Popularity 3/10 Helpfulness 2/10

answer excel vba code to copy filtered data

excel vba code to copy filtered data

Comment

Sub copy()
     'source worksheet
     dim ws as Worksheet
     set ws = Application.Worksheets("Data")' set you source worksheet here
     dim data_end_row_number as Integer
     data_end_row_number = ws.Range("B3").End(XlDown).Row.Number
    'enable filter
    ws.Range("B2:F2").AutoFilter Field:=2, Criteria1:="hockey", VisibleDropDown:=True
    ws.Range("B3:F" & data_end_row_number).SpecialCells(xlCellTypeVisible).Copy
    Application.Worksheets("Hoky").Range("B3").Paste
    'You have to add headers to Hoky worksheet
end sub

Popularity 3/10 Helpfulness 2/10 Language vb

Source: stackoverflow.com

Tags: copy excel filtered vba

Link to this answer
Share Copy Link