Quote (Magicalmaged @ 29 Nov 2013 12:09)
I'm assuming its more complicated than just copy paste lol
Hehe yes. I would call that manual work
Quote (ArnoldChlamydia @ 29 Nov 2013 21:40)
cant u just use ctrl+f then find + replace
dunno if its just excel 2013 or if im completely wrong
Yes this works fine for single/small amounts of replacements.
Quote (mungoflago @ 2 Dec 2013 01:30)
Did you ever get this?
Yes
Someone in an excel help forum gave me this code. It works perfectly, when you change the targets cells E1:F5 and A1:A100.
Code
Option Explicit
Sub Replace_Values()
Dim Replacement_Table As Range
Dim Rng As Range
Dim c As Range
Dim Match As Variant
Set Replacement_Table = Range("E1:F5")
Set Rng = Range("A1:A100")
For Each c In Rng
Match = Application.Match(c.Value, WorksheetFunction.Index(Replacement_Table, 0, 1), 0)
If Not IsError(Match) Then
c = Application.VLookup(c, Replacement_Table, 2, 0)
End If
Next
End Sub