I receive the excel report with about 80 different account numbers and
multiple charges against each account number. I can't tell by the account
number who the vendor is. How can I insert a column to populate it with
vendor names based on the account number. Can I setup some hidden table to do
this automatically once and for all? Any other method? Each account may have
multiple rows.
acct invoice date amount
123 12121212 01/15/09 $365.15
123 12121334 01/18/09 $105.00
125 30987652 01/16/09 $250.40

Thank you.