Private Sub UserForm_Initialize()
With Sheet1
BalanceSheet1.Range(.Range("D3"), .Range("D" & .Rows.Count).End(xlUp)) _
.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range("P3"), Unique:=True
Range("P3").AutoFilter
Range("P3:P6000").Sort Key1:=Range("P3"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
fClient.List = .Range(.Cells(4, 16), .Cells(.Rows.Count, 16).End(xlUp)).Value
End With
Addition.fClient.SetFocus
With Sheet1
BalanceSheet1.Range(.Range("G3"), .Range("G" & .Rows.Count).End(xlUp)) _
.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range("R3"), Unique:=True
Range("R3").AutoFilter
Range("R3:R6000").Sort Key1:=Range("R3"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Last1.List = .Range(.Cells(4, 18), .Cells(.Rows.Count, 18).End(xlUp)).Value
End With
With Sheet1
BalanceSheet1.Range(.Range("F3"), .Range("F" & .Rows.Count).End(xlUp)) _
.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range("T3"), Unique:=True
Range("T3").AutoFilter
Range("T3:T6000").Sort Key1:=Range("T3"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
First.List = .Range(.Cells(4, 20), .Cells(.Rows.Count, 20).End(xlUp)).Value
End With
With Sheet1
BalanceSheet1.Range(.Range("E3"), .Range("E" & .Rows.Count).End(xlUp)) _
.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=.Range("V3"), Unique:=True
Range("V3").AutoFilter
Range("V3:V6000").Sort Key1:=Range("V3"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Korean.List = .Range(.Cells(4, 22), .Cells(.Rows.Count, 22).End(xlUp)).Value
End With
Bookmarks