Sub Triedit() Dim x As String, a, i As Byte x = "L,W,Y" a = Split(x, ",") For i = LBound(a) To UBound(a) Call PoListoch(CStr(a(i))) Next i Sheets("Zdroj").Select Range("A1").Select Selection.AutoFilter End Sub Sub PoListoch(xList As String) On Error GoTo xErr Sheets(xList).Range("A1:B60000").ClearContents '"L" Sheets("Zdroj").Select Range("A1").Select Selection.AutoFilter Range(Range("A1"), Range("B60000").End(xlUp)).Select Selection.AutoFilter Field:=1, _ Criteria1:="=*_" & xList & "*", _ Operator:=xlAnd Selection.Copy Sheets(xList).Activate Range("A1").Select ActiveSheet.Paste Range("A1").Value = xList xErr: End Sub
Sub FilterCopyToOtherSheet() Dim xSht As String xSht = Mid(Sheets("Zdroj").Range("A2").Text, 3, 1) ' do ktoreho listu to pojde Sheets(xSht).Range("A1:X60000").ClearContents Sheets("Zdroj").Range(Range("A4"), Range("A60000").End(xlUp)).AdvancedFilter _ Action:=xlFilterCopy, _ CriteriaRange:=Sheets("Zdroj").Range("A1:A2"), _ CopyToRange:=Sheets(xSht).Range("A1"), _ Unique:=False End Sub
Užitočné (2) | avalik, Kabaka123 |
EXCEL - triedenie dat