Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 -- Queen T |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Queen T" wrote: 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 -- Queen T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
home monthly expense report | Excel Discussion (Misc queries) | |||
How do I set up a monthly business expense sheet | New Users to Excel | |||
I need a running total of monthly grocery expense | Excel Discussion (Misc queries) | |||
how do i make a monthly expense spread sheet | Excel Discussion (Misc queries) | |||
Template to track credit card expenses and expense reports combi | Excel Discussion (Misc queries) |