Need Help.
I receive Excel spreadsheet on a weekly basis. The spreadsheet contains the following information:
A = City Name, B = Court Date, C = Case #, D = Plaintiff, E = Defendant, etc.
What I am trying to do is to automatically put a service charge/dollar amount in Column X, which is dependent on the value in Column A.
For example: If the cities are Norfolk, Va Beach, Hampton, Chesapeake, etc, the amount to automatically be inserted is $10
If the cities are Richmond, Henrico, etc, the amount to be inserted is $12.
I am very new to Excel and/or computers. I would greatly appreciate any assistance.
Lastly, once the amounts are automatically inserted, I need a grand total at the bottom.
Please help.
Bookmarks