I have got a list of companys with abbreviated names with our purchase spend
with each company, I also have a master list of what the abbreviated names
full alternative. When I do a report at the end of each month the list comes
out with the abbreviated names but I want the full name. Is there a way to
swap the abbreviated name with the appropriate full name? Maybe using a VB
command. I am a novice at VB though so can anyone tell me exactly what to do
if there is a code.

Example

company amount abreviated full
A 1 A AYY
B 2 B BEE
D 4 C SEE
F 9 D DEE
E EEE
F EFF

company amount
AYY 1
BEE 2
DEE 4
EFF 9