DOSYA İndirmek/Yüklemek için ÜCRETLİ ALTIN ÜYELİK Gereklidir!
Altın Üyelik Hakkında Bilgi
Sub ALT_TOPLAM()
Application.ScreenUpdating = False
ActiveSheet.Cells.RemoveSubtotal
Range("J2").FormulaR1C1 = "=RC[-9]&RC[-8]&RC[-7]&RC[-6]&RC[-5]&RC[-4]&RC[-3]&RC[-2]&RC[-1]"
Range("J2").AutoFill Destination:=Range("J2:J" & [A65536].End(3).Row), Type:=xlFillDefault
Range("J1").FormulaR1C1 = "FİLTRE"
Range("A1").Select
Range("A1:J" & [A65536].End(3).Row).Sort Key1:=Range("J2"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Selection.Subtotal GroupBy:=10, Function:=xlSum, TotalList:=Array(8, 9), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
Range("G1:G" & [A65536].End(3).Row + 2).SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "TOPLAM"
Columns("J:J").ClearContents
Cells.EntireColumn.AutoFit
Application.ScreenUpdating = True
Range("A1").Select
MsgBox "İŞLEMİNİZ TAMAMLANMIŞTIR.", vbInformation
End Sub