I
Ivan808
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
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