+ Reply to Thread
Results 1 to 2 of 2

Function/Formula to extra rows from one range based on a date period to another range?

  1. #1
    Registered User
    Join Date
    08-10-2011
    Location
    Cali
    MS-Off Ver
    Excel 2013
    Posts
    53

    Function/Formula to extra rows from one range based on a date period to another range?

    I have a sheet with financial transactions on it, with columns for date, amount, description of the charge, etc etc. Each row is a separate transaction. This sheet auto-updates (not my code) with my transactions, so eventually at the end of the year it will have transactions from 1/1 through 12/31.

    On another sheet, I would like to extract all the transactions (data points) from the first range that fall into a given period between two dates, and pull the row data into a new range for some manipulation. Preferably, I could define the dates that bound the data I want dynamically in a few cells on the second sheet.

    So if I had 10 transactions a month for 12 months on Sheet1, I would want to go to Sheet2, enter a start data and an end date (say 1/1/2015 and 3/15/2015), and have all the transaction data between those two dates from Sheet1 infill below. Basically a filter on the first data range on Sheet1, except it would appear on Sheet2 (or 3, 4, 5, etc). Because the data on Sheet1 is basically my "master set" and I cannot screw anything up on it, I want to leave it untouched.

    Thoughts on the best/cleanest way to do this?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: Function/Formula to extra rows from one range based on a date period to another range?

    A few ways come to mind.

    1. Use advanced filters to do the extract (but this would be a manual process)
    2. Add a helper column to sheet 1 that would "number" the rows of interest, then use INDEX/MATCH to extract them
    3. Use something like a INDEX/SMALL array formula, but I would need to see a small sample of your data)
    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. Highlight Rows Based on Date Range Using Static Date and Current Date
    By SaraStravers in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-23-2015, 07:38 PM
  2. [SOLVED] Semi Monthly autofill Period Starting Date based on Period Ending Date
    By greatwent in forum Excel General
    Replies: 6
    Last Post: 01-30-2014, 03:29 AM
  3. Replies: 2
    Last Post: 06-07-2013, 02:21 PM
  4. Replies: 0
    Last Post: 05-30-2013, 07:50 PM
  5. Assigning period and quarter based on date range. VBA
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-28-2011, 09:04 PM
  6. Formula: Finding todays date minus min value from certain range + extra condition
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-04-2011, 10:21 AM
  7. Macro to allocate amt to different period, based on date range
    By raj8000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2009, 08:02 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