[mso] Excel help
- From: pamobsby@xxxxxxxxx
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 23 May 2007 14:27:32 +0100
I am quite a novice when it comes to Excel, however I have set up a budget
database for my club
There are 3 Cost Centres (Music, Singing and Presentation)
There are 5 people in the music team
I created a worksheet for each cost centre and enter all the details on
these three worksheets (Name, Expense Code, Date, Purchase Order Number,
Amount, Supplier, Description, Payment Method, File Date, Constructed Key
Field*) * Column that converts date "dd/mm/yyyy" to "mmm-yy".
I then created a "Monthly Summary" worksheet which gives me the total
monthly spend by Cost Centre and a Year To Date worksheet which includes
comparison of YTD figures for each cost centre against budget.
I am struggling to create worksheets for each of the music team to show
their individual spend by cost centre and month
Hope someone can help
phil
http://www.rac.co.uk
http://www.rac.co.uk/business
http://www.bsm.co.uk
Any opinions expressed in this e-mail are those of the individual and not
necessarily the company. This e-mail and any attachments are confidential to
RAC and/or BSM and are solely for use by the intended recipient.
If you are not the intended recipient you must not disclose, copy or distribute
its contents to any other person nor use its contents in any way.
If you have received this e-mail in error please forward a copy of this e-mail
to "Security@xxxxxxxxx".
RAC Motoring Services: Registered England 1424399
VAT Reg No. GB 238640945
British School of Motoring Limited: Registered England 291902
VAT Reg No. GB 239505847
RAC Financial Services Limited: Registered England & Wales 5171817
VAT Reg No. GB 238640945
Registered Office(s): 8 Surrey Street, Norwich, NR1 3NG
RAC Motoring Services and RAC Financial Services Limited are authorised and
regulated by the Financial Services Authority, both companies are members of
the Aviva group.
This e-mail and any attachments has been scanned for the presence of computer
viruses. RAC/BSM accept no responsibility for computer viruses once this e-mail
has been transmitted.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
