+ Reply to Thread
Results 1 to 2 of 2

suming daily information into weekly 5 or 7 day weeks, monthly, 3 monthly, 6 monthly

  1. #1
    Registered User
    Join Date
    06-25-2008
    Posts
    40

    suming daily information into weekly 5 or 7 day weeks, monthly, 3 monthly, 6 monthly

    hi


    Excel 2007
    I am entering information into an excel sheet one day/column at a time. So 2/08/08 is sitting in column c 1/08/07 is sitting in column d and so on rolling back along the sheet. This allows me masses of day that I can store.


    What I wish to do is to take the information that is sitting per day in “sheet 1” put it into “sheet 2” in weekly a weekly layout, with the information average or added together.


    Then take the information in the weekly, do the same paste it in “sheet 3” per calendar month, “sheet 4” per 3 months “ sheet 5” per 6 months and “sheet 6” per year.

    This would have to all update daily as new information is entered. And I would like the Macro to be as efficient as possible doing so.

    I have struggled to do this, and have been doing it manually typing in the formulas going back 7 and so on days at a time. And it is really slow when the macro copies what I have done.

    Can any one show me a more efficient easier way of doing this?

  2. #2
    Registered User
    Join Date
    10-09-2007
    Posts
    10
    According to me, you should not enter the data in different columns but in one column and then use a pivot table...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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