[mso] an EXCEL question
- From: Joyce West <joywestuk@xxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Sat, 4 Oct 2003 15:50:25 +0100 (BST)
Hi Ray.
The daily sales are generated by direct entry.
The are many customers so there are quite alot of
entries.
They are collectd and total at the right hand side of
the daily sales with eg SUM(C3:23)
These are totalled at the bottom of the section to
obviously give a total.
On the same sheet and below the daily sales record
there is another section which reads each individual
customers weekly sales figure ie =J3 and so on.
To the right of this section is the accrued total for
the yearly sales to which I wish to add the weekly
sales week on week, but the problem is that if the
yearly sales are generated from the weekly sales, and
the weekly sales are overwritten on the weekly sales
sheet, then the values for past weeks are lost unless
I can somehow fix them to remain in the yearly to date
column.
The only way I could think of doing it was to have a
weekly sales sheet for each week of the year, reading
into the yearly sales figure.
I think I have got myself into a mess somewhat inamuch
that I would also like to have a chart record of each
customer sales trend of the yearly period.
Perhaps it might be better to start again with a
different concept. What do you think?
Many thanks for your perseverance.
Norman West
________________________________________________________________________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk
*************************************************************
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, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
