+ Reply to Thread
Results 1 to 3 of 3

Automatically create monthly totals from daily data

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    1

    Automatically create monthly totals from daily data

    hi, im trying to do an automatic input with my daily total sales.. i did it in total but my problem is i don't know how to make the date change.

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Automatically create monthly totals from daily data

    Hi honeylhany143

    Welcome to the forum

    I do get a little tired hen someone goes into great depth describing a problem, but you seem to have gone to the opposite extreme!

    Perhaps if yu were to upload a sample of what you have and what you want (all sensitive data removed) it would help people see exactly what you are try ing to achieve

    Regards
    Alastair

  3. #3
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Automatically create monthly totals from daily data

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. summing daily weekly & monthly totals
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-10-2014, 04:49 PM
  2. [SOLVED] Daily data conversion to Monthly totals
    By akumagaavese in forum Excel General
    Replies: 9
    Last Post: 09-11-2013, 02:16 PM
  3. [SOLVED] How do I group daily totals into weekly/monthly/quarterly totals
    By situationroom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2013, 09:58 AM
  4. Automatically create monthly totals from daily data
    By mundo in forum Excel General
    Replies: 6
    Last Post: 01-02-2009, 05:33 AM
  5. [SOLVED] Collecting weekly and monthly totals from daily data
    By Kasper in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-12-2006, 04:10 PM

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