+ Reply to Thread
Results 1 to 5 of 5

Macro to aggregate data from date to date

  1. #1
    Registered User
    Join Date
    06-17-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    25

    Macro to aggregate data from date to date

    I need the revenue and cost per company to be added in B3:C7 when I specify the dates I want in F3 and F4.

    Thanks for the help!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,726

    Re: Macro to aggregate data from date to date

    This is an array formula solution that will require a modification in the data arrangement, as in the date needs to be placed above the Revenue and cost columns. Once that has been done paste this formula in B3, press the F2 key, then press the Ctrl, Shift and Enter keys simultaneously:
    Please Login or Register  to view this content.
    Here is a copy of your file with the modifications and formula applied: Copy of Revenue&Cost.xlsm
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,726

    Re: Macro to aggregate data from date to date

    Here is an array formula* that will allow the date to be centered over the "Revenue" column only as in the original version of the file attached to post #1:
    Please Login or Register  to view this content.
    *Paste the array formula in B3, press the F2 key, press the Ctrl, Shift, and Enter keys simultaneously, Copy down to B7 and across C7.
    Let me know if you have any questions.

  4. #4
    Registered User
    Join Date
    06-17-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Macro to aggregate data from date to date

    Thank you so much works great!

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,726

    Re: Macro to aggregate data from date to date

    You're Welcome and thank you for the feedback. If you haven't already please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.

+ 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. Macro to lookup data monthwise and aggregate the value in a new sheet
    By yemnirmal in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-13-2015, 05:36 AM
  2. [SOLVED] Aggregate exact date
    By SEMMatt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2014, 10:35 PM
  3. [SOLVED] Macro to match date in data table and copy cell range containing date.
    By 54ed in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2014, 04:52 AM
  4. Counting if data falls on date between Start Date, End Date or Possible End Date
    By JessHasQuestions in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-26-2014, 08:01 AM
  5. [SOLVED] Macro to update pivot item (date format) in pivot table to latest date from data source.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2012, 03:18 AM
  6. Macro for converting aggregate to case level data
    By epi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-27-2010, 09:45 AM
  7. aggregate multiple transactions with same date...
    By Georgia Golfer in forum Excel General
    Replies: 12
    Last Post: 03-17-2010, 02:46 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