Selam arkadaslar, bu konuyla ilgili bir gonderi buldum fakat hic ise yaramiyor benim kullanmis oldugum makroda.
Elimde bulunan sirali bi liste var ornek//
i11-GlitterBumper-Lilac
i11-GlitterBumper-Mint
i11-GlitterBumper-Pink
i11-GlitterBumper-White
yukarida ki listeye karsilik gelecek satis sayilari var..ornek//
i11-GlitterBumper-White 8
i11-GlitterBumper-mint 5
i11-GlitterBumper-lilac 8
i11-GlitterBumper-pinK 4
Makroyu calistirdigim zaman sadece "i11-GlitterBumper-White " duzgun calisiyor... diger 3'u sanirim harf duyarliligina takiliyor. makro asagida " Option Compare Text" ise yaramadi bende.
Private Sub RunTheExcelForm2_Click()
'Updateby Extendoffice
Dim WorkRng As Range
Dim Dic As Variant
Dim arr As Variant
On Error Resume Next
xTitleId = "Application will start soon"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
Set Dic = CreateObject("Scripting.Dictionary")
arr = WorkRng.Value
For i = 1 To UBound(arr, 1)
Dic(arr(i, 1)) = Dic(arr(i, 1)) + arr(i, 2)
Next
Application.ScreenUpdating = False
WorkRng.ClearContents
WorkRng.Range("A1").Resize(Dic.Count, 1) = Application.WorksheetFunction.Transpose(Dic.keys)
WorkRng.Range("B1").Resize(Dic.Count, 1) = Application.WorksheetFunction.Transpose(Dic.items)
Application.ScreenUpdating = True
End Sub
Elimde bulunan sirali bi liste var ornek//
i11-GlitterBumper-Lilac
i11-GlitterBumper-Mint
i11-GlitterBumper-Pink
i11-GlitterBumper-White
yukarida ki listeye karsilik gelecek satis sayilari var..ornek//
i11-GlitterBumper-White 8
i11-GlitterBumper-mint 5
i11-GlitterBumper-lilac 8
i11-GlitterBumper-pinK 4
Makroyu calistirdigim zaman sadece "i11-GlitterBumper-White " duzgun calisiyor... diger 3'u sanirim harf duyarliligina takiliyor. makro asagida " Option Compare Text" ise yaramadi bende.
Private Sub RunTheExcelForm2_Click()
'Updateby Extendoffice
Dim WorkRng As Range
Dim Dic As Variant
Dim arr As Variant
On Error Resume Next
xTitleId = "Application will start soon"
Set WorkRng = Application.Selection
Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
Set Dic = CreateObject("Scripting.Dictionary")
arr = WorkRng.Value
For i = 1 To UBound(arr, 1)
Dic(arr(i, 1)) = Dic(arr(i, 1)) + arr(i, 2)
Next
Application.ScreenUpdating = False
WorkRng.ClearContents
WorkRng.Range("A1").Resize(Dic.Count, 1) = Application.WorksheetFunction.Transpose(Dic.keys)
WorkRng.Range("B1").Resize(Dic.Count, 1) = Application.WorksheetFunction.Transpose(Dic.items)
Application.ScreenUpdating = True
End Sub