+ Reply to Thread
Results 1 to 2 of 2

Need Help creating an Excel Sheet for Daily sales

  1. #1
    Registered User
    Join Date
    08-09-2013
    Location
    ny
    MS-Off Ver
    Excel 2003
    Posts
    1

    Need Help creating an Excel Sheet for Daily sales

    Hey everyone
    I need a bit of help Im looking to create an excel sheet for my sales reps. They get monthly sales quotas and I want to break it down to daily goals and then put in what they actually achieve to see if they are falling behind daily.

    for example : for August one rep needs to sell 61 units. They work 23 days for the month. I would like to break it down to daily goals so if the daily goal is 3 and they only sold 2 the last 4 days I would like it to tell me what their daily goal would then be.

    I hope this makes sense to someone! and that someone might be able to help

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Need Help creating an Excel Sheet for Daily sales

    Hi and welcome to the forum

    This sounds pretty straight-forward, but have you started putting anything together for this yet?

    Members here are more than willing to help you with problems, but we are not here to do the work for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. summarize monthly sales from daily sales
    By top1 in forum Excel General
    Replies: 4
    Last Post: 01-05-2010, 11:59 PM
  2. Excel Sheet for Daily Sales
    By haxmania1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-22-2009, 04:55 PM
  3. [SOLVED] cumulating by adding previous sales to daily sales
    By kish_gv in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2007, 03:38 AM
  4. Creating a Dynamic Inventory List Based on Daily Sales
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-29-2005, 11:01 AM
  5. [SOLVED] I need a daily sales sheet to pull from monthly figures sheet
    By Draegen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2005, 05:26 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1