Hi,I have a spreadsheet where I list my cash dispersements, I enter in the
payee and dollar amount information. What I want to do now is to be able to
enter a reference code for each payment (ex: Utilites, office expenses,
Repair etc...) and have the dollar amount (in column B) automatically copied
to a corresponding column further down, based on the reference code value I
enter in column C.

Example:
(A) (B) (C) (D)
(E) (F) (G)
Payee Amount Reference Utilites Supplies
Maintenace Misc
company a $100 utilites 100
company b $75 supplies 75
company c $60 maintenance
60


Also, Is there a way to use AutoSpell, or something similar, in Excel's
worksheets instead of typing every single company name out every time?

Any help would be greatly appreciated, thank you.
Ivan