Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Sales Reports

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does anyone have any examples of sales report templates that I can view. I am working on updating/creating a new sales report for the company and I need suggestions.

    We have 2 departments with approximatly 40 sales reps in each. I need a spreadsheet for each salesrep to measure their revenue generated, commission, account adjustments, revenue transfer. A sheet for each department and a summary sheet. This sounds more easy that it really is.

    Any links to websites would also be useful.

    Thanks
    mr_parra@hotmail.com

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You might want to ask Jay P for a file he made for me not too long ago.

    It was vacations instead of sales, but the same process was involved.
    ~Anne Troy

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    The file is at work. I will send it to you tomorrow. Dreamboat, I have your blessing to send it?

    Also, I sent you a private e-mail last week regarding a project you were working on, where I spaced on the message until late Friday. If this is the same, I still have it. If not, please send it to my work address and I will work on it tomorrow. I promise I won't space out on it this time.

    john.petrulis@notes.ntrs.com

    Bye,
    Jay

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ?

    Spaced out?

    You talking to me? Everything you did for me was BEAUTIFUL, Jay. Thanks!!

    Send the file! Feel free to give out. I highly doubt anyone would recognize the names. I don't!
    ~Anne Troy

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Location
    Kent, the Garden of England, that no one has bothered to weed.
    Posts
    65
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can I be really cheeky and request a copy of that file too. It will probably help me enormously, I need to create something too and i'm struggling.

    statto88@blueyonder.co.uk

    many thanks

  6. #6
    New Member
    Join Date
    May 2002
    Location
    Strider
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Speaking of Cheek ... I'm creating a grade book for my wife & would greatly appreciate any report help I can get would be greatly appreciated.

    jmoore@sdcoe.k12.ca.us

  7. #7
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jay: That file seems pretty popular. Think we could change the names and properties and make it a download? I've been so busy. I had another file from you too, right? Oh! I remember!

    Anyway, any good files like that, I'm willing to load them up for download at http://www.thewordexpert.com/downloads.htm
    ~Anne Troy

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Dreamboat

    downloads i have made noise, maybe you can have a word inside MVP, as this would really help guys, im behind this.

    I thank you on behalf of all allowing your web space to be used.

    Cheers

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  9. #9
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Actually, Jack, I don't pay for my web space. I do a little Access work now and then for the hostess, and a terrific hostess she is. She doesn't need some Access developer or anything, but it sure would cost her a lot to find someone that can do what I can for her, because *average* Access experts don't advertise for work. It's worked out VERY well TheWordExpert, and I'm a *share-the-wealth* kind of gal.

    If you have any suggestions for downloads, Jack, I hope you'll let me know!

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes i have as my above post said fought to have attachment in the posts, but thats not workable so easy from a tech point of view.

    Also say you said OK, ill have my site with Download areas, who decides what up there???

    OK we can say the goodie as i called them Audiojoes say was worth but they must be that good, and free to all,

    Again we tread on the merky world o the internet and this might not be so workable, on V90 56k modem wire connections, the US have ADSL the UK its getting there, im in no rush but other guys will find a 1MB file impossable to leach down.

    Security and attack is an issue, we all know the enamy is within.

    The worlds full of fools and wee need to cater for tjis in any approach we make, else so IDIOT will infect the downlaods and all sort..

    Yup i am fully protected, so i can check any files as i need, deep. but i was subject to a campaign of attack, and all failed, even the hacker.. FAILED ho hum!

    Worth thinking about... ill look into this more and how to make ithe area JACK tight security else i want no part in it, not worth the risk, email between us is safer otherwise.

    Macro virus are not that bad and rare now days, laroux II poped up the other day at work, i was not allowed a copy of that, sadly....

    I have Laroux I so can test a secure area, ill look into this.



    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •