etusch
01-11-2017, 12:15 PM
18001
Hı.
I neet to copy words from table one to the table two (which is shown lower side of the picture ) At first table there could be same word many time in different rows. But I need to delete doubles in second table. After deleting doubles I need to sort them alphabetically. I am not programer. I googled for codes and found a way to copy from first table to second. But I can't find a way to delete doubles and sort.
Here my copying code
Sub deneme()
Dim myCells As Range
With ActiveDocument
Set myCells = .Range(Start:=.Tables(1).Cell(1, 4).Range.Start, End:=.Tables(1).Cell(4, 4).Range.End)
myCells.Select
Selection.Copy
End With
ActiveDocument.Tables(2).Cell(Row:=1, Column:=1).Range.Text = "Dağıtım:"
ActiveDocument.Tables(2).Cell(Row:=2, Column:=1).Range.Text = myCells + "etuusch"
'Selection.Paste
End Sub
Hı.
I neet to copy words from table one to the table two (which is shown lower side of the picture ) At first table there could be same word many time in different rows. But I need to delete doubles in second table. After deleting doubles I need to sort them alphabetically. I am not programer. I googled for codes and found a way to copy from first table to second. But I can't find a way to delete doubles and sort.
Here my copying code
Sub deneme()
Dim myCells As Range
With ActiveDocument
Set myCells = .Range(Start:=.Tables(1).Cell(1, 4).Range.Start, End:=.Tables(1).Cell(4, 4).Range.End)
myCells.Select
Selection.Copy
End With
ActiveDocument.Tables(2).Cell(Row:=1, Column:=1).Range.Text = "Dağıtım:"
ActiveDocument.Tables(2).Cell(Row:=2, Column:=1).Range.Text = myCells + "etuusch"
'Selection.Paste
End Sub