Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Producing expense (monthly) reports in Excel

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   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Producing expense (monthly) reports in Excel

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
home monthly expense report tennis pro Excel Discussion (Misc queries) 1 January 13th 07 08:07 PM
How do I set up a monthly business expense sheet debccv2006 New Users to Excel 1 January 4th 07 01:55 PM
I need a running total of monthly grocery expense Joe McCart Excel Discussion (Misc queries) 2 January 26th 06 12:06 PM
how do i make a monthly expense spread sheet making a expense report on excell Excel Discussion (Misc queries) 2 November 26th 05 05:43 PM
Template to track credit card expenses and expense reports combi sunshinelover Excel Discussion (Misc queries) 2 August 18th 05 02:58 AM


All times are GMT +1. The time now is 05:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"