This is a reminder of 3 IMPORTANT RULES:
1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.
2- Do NOT post in other languages. English-only.
3- Crack/Warez/Piracy talk is NOT allowed.
Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.
Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.
Thank you!
Gigee;3317734 said:Boots id please
Sub Change()
Dim rng As Range, rng2 As Range, cl As Variant
Set rng = Range("A1").CurrentRegion.Columns(1)
Set rng2 = rng.Offset(, 1).Resize(rng.Rows.Count, 2)
For Each cl In rng.Cells
If Application.WorksheetFunction.CountIf(rng.Offset(, 1), cl.Value) > 0 Then
rng.Replace What:=cl.Value, Replacement:=Application.WorksheetFunction.VLookup(cl.Value, Cells(1, 2).Resize(rng.Rows.Count, 2), 2, 0), LookAt:=xlWhole
End If
Next
End Sub
root4rulez;3321997 said:i need the players id - names
regularcat;3322130 said:so export the tables & get them bro, its a lot to ask someone to do.
root4rulez;3322136 said:When export i dont see the name of the player
hayman;3321845 said:You can get 'em yourself. It ain't that hard.
Use DBM12 and export de players and the playernames tables. Open it in Excel.
Filter in "players" on "headclasscode" 0 = specific and 1=generic.
Then cut the line lastnameID from "players" into "playernames".
Make sure it's: 1: lastnameID, 2: nameID 3:name
Then create/use the following macro:
Code:Sub Change() Dim rng As Range, rng2 As Range, cl As Variant Set rng = Range("A1").CurrentRegion.Columns(1) Set rng2 = rng.Offset(, 1).Resize(rng.Rows.Count, 2) For Each cl In rng.Cells If Application.WorksheetFunction.CountIf(rng.Offset(, 1), cl.Value) > 0 Then rng.Replace What:=cl.Value, Replacement:=Application.WorksheetFunction.VLookup(cl.Value, Cells(1, 2).Resize(rng.Rows.Count, 2), 2, 0), LookAt:=xlWhole End If Next End Sub
Use the same trick and macro on 1:commonnameID 2: nameID 3:name
And VOILA! Put commonname ID and lastnameID together and you'll have your list!