Producing expense (monthly) reports in Excel

[Queen T]

I need to be able to produce monthly expense reports for my job. I have
tried to 3 D reference to do some of this, however I am unsuccessful with
doing it the way I know it should be done. I have to enter expenses in
excel spreadsheets. And now my job requires me to use accounting codes to do
my work as well. I know there is a way to do this to be able to just "plug
in" if you may this data and produce these reports. I just can't seem to get
it to do and look like I want it to. Help

 

[dlw]

somewhere in the spreadsheet, make a list of the account codes, then
highlight the cells where you will enter the code, from the menu, pick
data/validation, allow, list and select the list of account codes. Then when
you enter those cells, you will get a dropdown list of the codes to pick from